betsy, welcome to the forum.

Are the "$XX" values you are referring to in the same cell as eg "Production:Melchior Productions LLC:1A-Melchior Production Expenses:003A_Architect"? It isn't immediately clear from your post if that's the case.

Your best bet, in fact, is probably to upload a small sample of the data you're dealing with, with anything sensitive removed.

Hope this helps.