Hai, i need to aska question no k?
i have copied a long list of email address from an email, all seperated by semi colons, but when pasted into excel they drop into one cell, I want them to have a cell each.


any ideas?
( Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:11, 3 replies, latest was 12 years ago)

Used to be something like File - import/export - export to file
But I'm not at my work machine, obv. I don't have excel on this.
( Kroney, Tue 5 Mar 2013, 14:12, Reply)

Import and use ; as a delimiter

( sporters I’m sincerely gratitude to you, Tue 5 Mar 2013, 14:12, Reply)

I gonna need more explict instructions...

( Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:13, Reply)

Paste all the email addresses into a Notepad or Word document
Save
Open Excel
File - Open
Change dropdown to .doc or .txt, whatever you saved as
Select Delimited - Next
Clear everything apart from semicolon
Click Finish
Profit
( sporters I’m sincerely gratitude to you, Tue 5 Mar 2013, 14:16, Reply)

Surely Text To Columns would be quicker?

( Agnostic Antichrist Baltimora, Tue 5 Mar 2013, 14:20, Reply)

that's what i did, there's a button

( Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:20, Reply)

it's alright i dunnit THX!!! xxxx

( Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:14, Reply)

b3ta.com/questions/offtopic/post1885581
( Kroney, Tue 5 Mar 2013, 14:15, Reply)

Or paste in one cell, edit, text to columns, delimit by ;

(localboy purveyor of pisspoor puns, Tue 5 Mar 2013, 14:14, Reply)

yeah that's what i dun in the end

( Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:15, Reply)

You are now almost qualified to work in IT
Can you be unhelpful and patronising on the phone?
( tangledupinblue hairy badge with moving eyes, Tue 5 Mar 2013, 14:19, Reply)

yeah, dur

( Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:20, Reply)

*resigns job*

(localboy purveyor of pisspoor puns, Tue 5 Mar 2013, 14:20, Reply)