"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
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