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...
 
Top