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

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
0