Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

"TEXT TO COLUMN" formula for numbers

Hi,

I have an imported an excel spreadsheet and I have a column(A) that has a header with: Mail City/Mail State/Mail Zip within that column(A) the data reads: New Orleans LA 70122.

I need a formula that will take the text and place each item( 3 in this case, Mail City/Mail State/Mail Zip) in it's own seperate column with its designated info.

I know that this is a simple click "text to column" in excel but no so much in numbers

Thanx

Posted on Nov 4, 2010 9:58 AM

Reply
2 replies

"TEXT TO COLUMN" formula for numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.