Extracting Multiple Values From One Cell

E

Erwin

I copy/pasted an address list from an HTML source. One column contains cells
that have City, State and Zip information separated by a space. How can I
move those three [or two] pieces of information, each into its own cell.

Thanks,
 
B

Biff

Hi Erwin!

Use the text to columns feature for this.

Select the range of data.
Goto Data>Text to Columns.
Select: Delimited , Next
Check: Space , Finish

Biff
 
E

Erwin

Bingo. Thank you.

--
Erwin


Biff said:
Hi Erwin!

Use the text to columns feature for this.

Select the range of data.
Goto Data>Text to Columns.
Select: Delimited , Next
Check: Space , Finish

Biff
-----Original Message-----
I copy/pasted an address list from an HTML source. One column contains cells
that have City, State and Zip information separated by a space. How can I
move those three [or two] pieces of information, each into its own cell.

Thanks,

--
Erwin


.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anything will help 0
Un-Concatenate 3
batch extract all tables from multiple word documents 1
Merging from an Excel file with graphics 1
data from multiple files: best way to extract 1
Line Breaks in cells - Mac OS X Leopard 1
Transposing an Address List 2
move data that occupies multiple rows/columns into one row 3

Top