Good afternoon.
Hoping someone can help with this issue:
I have a simple spreadsheet with three cells next to one another. Assume they're A1, B1, and C1.
A1 contains a date.
B1 contains a dollar amount.
C1 contains a text string.
At work, I make payment arrangements and have to copy and paste this information into a third party software. When I do this, I get really ugly spacing. Something like:
5/16__________$100.00__________to acct 1234567890
Deleting the large spaces manually is too time consuming. So I tried putting all the info into one cell like this: =A1&" "&B1&" "&C1
This solved the issue of the spacing, but I lose the formatting. The result looks like:
"42506 100 to 1234567890"
How do I get all three pieces of information into one cell with the formatting (date & dollar amt) and without the huge spaces between them? I'm trying to create this for users who are... *ahem* "Unsophisticated" when it comes to Excel. They need to be able to plug in data, copy, paste and move on.
Thank you for taking the time to read this and I look forward to your thoughtful replies.
Bookmarks