How can i separate a list with a space and comma?

Advertise on BHW
I'd just use the replace function in notepad

get it to replace ".com" with " ," (space comma)

then repeat with all extensions (.net, .co.uk etc)

Bit hard to see what you really want with that thin sliver of an example!
 
If you do this ofter, you are better off getting the SoborSoft Extract Email from Text File. Then, you can save it as a list or as a comma.

I know there are ways to do it with Excel but I have never learned since instead, I use the program above.
 
partymarty4870 said:
I'd just use the replace function in notepad

get it to replace ".com" with " ," (space comma)

then repeat with all extensions (.net, .co.uk etc)

Bit hard to see what you really want with that thin sliver of an example!
Click to expand...
Thanks! I didn't even think of that :)
 
JimmyConway said:
Consider using Microsoft Excel for storing lists. It's much more efficient than notepad.
Click to expand...

Tell him how and I'm sure he will.

Question: How can I send a lot of email
Answer: Try using a computer and you can send a lot.
 
It really is not that hard to copy and paste something into excel and save it.

Question: Why try and mock someone when they were just trying to help?
Answer: Obviously, there is a lack of interesting things going on in that persons life.



CoyoteAssassin said:
Tell him how and I'm sure he will.

Question: How can I send a lot of email
Answer: Try using a computer and you can send a lot.
Click to expand...
 
JimmyConway said:
It really is not that hard to copy and paste something into excel and save it.

Question: Why try and mock someone when they were just trying to help?
Answer: Obviously, there is a lack of interesting things going on in that persons life.
Click to expand...

Haha... Until I read your reply.

How does the OP copying and pasting text into Excel do anything for him? In my example, that is equal to buying a computer and turning it on.

If you are trying to help, the prove it. Paste step-by-step how to turn his list into what he needs.

OP - Another suggestion is to download ASAP Utilities (its free). It's the most powerful plugin I have ever used for Excel. Select your data, select the Text menu (in ASAP Utilities) and click the first option 'Insert Before/After Each Selection' and in the After box, put a comma and space.

Another, longer option is to paste your records in Excel, and create a new column and in it, only have a comma and space and merge them together. Then, copy that into a .html file and when you open it in a browser, it will all be in a continuous format as you requested.

As you can see, there are multiple ways to do this. Some easier than others but some are more easy for a one-time operation. See what Jimmy says though.
 
I gave him a piece of advice regarding organization. A step by step guide you say? Would you like me to hold his hand as crosses the street as well? You saying "prove this", has little affect on the real world, man. You need to grow and stop attempting to get at people on a forum, it's pretty pathetic. OP, good luck with your data entry.
 
JimmyConway said:
I gave him a piece of advice regarding organization. A step by step guide you say? Would you like me to hold his hand as crosses the street as well? You saying "prove this", has little affect on the real world, man. You need to grow and stop attempting to get at people on a forum, it's pretty pathetic. OP, good luck with your data entry.
Click to expand...

Maybe you didn't realize he said "How do I". Not "What program should I use".

If you are going to walk your gf/wife to the car, you don't just walk to the door and stand there like an idiot - you either open and close the door or you don't offer to do anything. You had a chance to help and blew it as far as I'm concerned.

BHW is a great community of people helping people and sometimes that means step-by-step. If he asked you how to market his site with SEO, I would not expect full details.

As far as the real world goes, it does work as I said. You either put up or shut up! Simple as that.

What is pathetic is when people respond to question with an answer that is of no use in helping them do what they need to do.
 
Hey if list is small
You can use following formula
=concatenate(cell1,","," ",cell2,","," ",...............cell n)

Otherwise, use macros to work with with a big list
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top