I have an Excel workbook with 6 columns. I need to combine them into one cell but maintain a specific number of characters per column.
Example:
Name Orders Dollars MTD Ord MTD Doll % of goal
Name 1 $1,000 10 $1,000,000 15%
Name would need to be 8 characters no matter the contents. Dollars would need to be 8 digits etc......
It needs to automatic, so a formula would be easiest.
This is sent to a LED sign and needs very specific formating.
Any suggestions?
Example:
Name Orders Dollars MTD Ord MTD Doll % of goal
Name 1 $1,000 10 $1,000,000 15%
Name would need to be 8 characters no matter the contents. Dollars would need to be 8 digits etc......
It needs to automatic, so a formula would be easiest.
This is sent to a LED sign and needs very specific formating.
Any suggestions?