Previous Topic Next Topic

Separating string into different columns

Closed
Parle - 21 May 2010 à 14:14
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 May 2010 à 02:48
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

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

Similar discussions

How to convert number into text in Excel
boratechandu -
Raj -

9 responses
Match value in 2 separate columns and return a value from a 3rd
JD_Silver -
TrowaD -

1 response
how to convert Date into text.
rk gupta -
TrowaD -

1 response
Convert data with rows into columns
pooja.bs -
TrowaD -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses