Text Strings Conversion

  • Thread starter Thread starter billyccarver
  • Start date Start date
B

billyccarver

I have a text string that is in all one cell and I want to convert
portions of the string into seperate cells. Can anyone help me with
the formula for that?
Here is what the string looks like:

ALLEN, BILL,"9654 N 6620 W",,"CASEYVILLE","AZ","84487"


I need each of the name, address, city state and zip in sererate
cells.
thanks!
 
Use Data>Text to Columns... to separate these into different cells. Set
it as Delimited and choose Comma as the delimiter.

Good Luck
 
You must log in or register to reply here.

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

find and replace numeric strings in larger text strings 8
A find formul looking at two named ranges for two strings 6
Splitting Text from single cell in column across multiple Columns 3
Seperating information in a cell 9
Searching the formula (not the value) for a text string 1
Is there a function that will evaluate a text string in a cell? 2
Remove certain characters from a text string 6
Constructing Range Name calls with Concatenate 4

Back
Top