Excel Excel 2010


Joined
Jul 22, 2012
Messages
1
Reaction score
0
How to undo a CONCATENATED file created by CONCATENATING two columns?

mosheavron
 
Ad

Advertisements

Joined
Mar 20, 2012
Messages
764
Reaction score
4
What does the data look like now? It depends on if the stuff you want to separate out is all the same length, or if there is a variable to it. If you wanted to take the first 5 characters in one column and the last 7 characters in another, you would use =RIGHT(a1,5) in one column, and =LEFT(a1,7) in another to pull it apart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel 2010 2
Excel MSO 2010 - Excel 3
Excel EXCEL 2010 HELP 1
Excel 2010 vs. Excel 2016 3
Excel "Sparklines" (Excel 2010) 0
Excel Old Excel toolbar in Excel 2010 0
Excel Excel 2010 Full View 2
Excel Excel 2010 Corrupt Files 3

Top