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?

Separating string into different columns
Tweetdeck larger columns - Guide
Vba select case string contains - Guide
Display two columns in data validation list but return only one - Guide
Excel count occurrences of string in column - Guide
How to remove columns in word - Guide

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

Excel Macro/Code help: Creating sheet for each name in column of another sheet

formula if you have credit in one column, debit in next column

Copy range data in a column to new column.

Similar discussions

Subscribe To Our Newsletter!