force new cell

  • Thread starter Thread starter cathal
  • Start date Start date
C

cathal

I have copied a series of bcc-d e-mail addresses from ms outlookan
pasted to a spreadsheet. Each address is seperated with ; However
all the e-mail addresses appear in one cell. Is there any way o
getting each e-mail address to occupy a different cell (in the vertica
direction)?

One way is to do text to columns, use fixed delimiter, then ultimatel
transpose the seperated addresses.

Is there another way?

thanks, cathal.
 
Cathal,

Do a Data>Text To Columns with a ';' delimiter, and then do a Copy
PasteSpecial Transpose

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top