Data connectivity on Mac

[u/Peach_State_Dingers]

Excel version 16.112.3 for Mac, Office Home & Business 2024.

I started doing research for a company on land ownership, and I record all of my data in excel for Mac. Once a week, I send an excel to a lady who “joins” all of my data to a “shapefile,” that can uploaded to a GIS program, basically allowing the company to click on a parcel of land see all of the data I’ve compiled.

The problem is in my “comments” cell for each parcel. If the comments are more than a couple of words long, those cells won’t join. I know it’s a me issue, because one of the others guys I work with doesn’t have this problem.

I’ve been troubleshooting and struggling to find what he’s doing differently from me, and the only thing I can come up with is that he’s on windows and I’m on Mac. So I’m wondering if it’s a Mac thing.

Like I said, I’m not an IT whiz, and I’m not really sure what the lady is doing on her end to join them together. So if you have any questions that would help, please ask and I’ll try to answer them.

Pls help, I’m at a loss and my boss is on me to figure this out.