Previous Topic Next Topic

Separating string into different columns

Closed
Parle - May 21, 2010 at 02:14 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 22, 2010 at 02:48 AM
Hello,

I am working in an Excel Spreadsheet where I have a column that looks like this:

Column
XYZ Engineers #### Lincoln Ave., Suite ### San Jose CA #####

Is there a way to split it into different columns such that the name, the street address and City,State ZIP is in three different columns?

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 22, 2010 at 02:48 AM
Under data there is a feature called text to column, you can use it do so

Similar discussions

Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes
jackied25 -
TrowaD -

2 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
Insert Line Number for Two Columns Document
Karthikeyan N -
CrazyOliv -

3 responses