Hi All,
Here's my issue today. I've got a spreadsheet template that I receive where I need to extract data from 6 different columns and have the results in one cell in a new column. I've tried using concatenation with spacing, but couldn't some up with a universal formula that fits my needs.
The data in each column has to start in a particular position in the new cell. Hopefully the attached spreadsheet explains what I need more clearly. Not sure if this can be done with a formula, VBA, or maybe not at all, but I'm spinning my wheels and thought I'd ask for the experts help.
Offering up $20 but if a more complex solution/programming is needed, that is negotiable.
Sent 10% to Oz. Transaction ID 9DV743169J592954U
Thanks for taking a look!