Excel Excel 2010

alow

alow

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 2010 vs. Excel 2016 3
Concantenate which keeps bold of some parts. 5
Excel MSO 2010 - Excel 3
Excel Concatenate with line breaks but ignore blank cells 3
Excel Old Excel toolbar in Excel 2010 0
Excel Concatenate cell data from column based on criteria in adjacent column 2
Access Subscript out of range when importing into access 2010 from excel 0
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6

Top