b3ta.com qotw
You are not logged in. Login or Signup
Home » Question of the Week » Off Topic » Post 1885661 | Search
This is a question Off Topic

Are you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.

(I helped save b3ta! rob, Sun 1 Apr 2001, 1:00)
Pages: Latest, 836, 835, 834, 833, 832, ... 1

« Go Back | See The Full Thread

Import and use ; as a delimiter

(I helped save b3ta! sporters I’m sincerely gratitude to you, Tue 5 Mar 2013, 14:12, 2 replies, latest was 12 years ago)
I gonna need more explict instructions...

(I helped save b3ta! 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
(I helped save b3ta! sporters I’m sincerely gratitude to you, Tue 5 Mar 2013, 14:16, Reply)
Surely Text To Columns would be quicker?

(I helped save b3ta! Agnostic Antichrist Baltimora, Tue 5 Mar 2013, 14:20, Reply)
that's what i did, there's a button

(I helped save b3ta! Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:20, Reply)
it's alright i dunnit THX!!! xxxx

(I helped save b3ta! Naked Ape call me Caitlyn, Tue 5 Mar 2013, 14:14, Reply)

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

« Go Back | See The Full Thread

Pages: Latest, 836, 835, 834, 833, 832, ... 1