Anyone good with Excel?

[Guest barackobama]

I use OPENOFFICE.

 

 

Question//

 

if I have for example, say I have lots and lots of

 

Hello, Hello, Hello, Hello, Hello, Hello, Hello, Hello, Hello, Hello,

 

and I want it to go (without the comas to this) =

 

Hello

Hello

Hello

Hello

Hello

Hello

Hello

Hello

Hello

 

or the same but Hello hello hello Hello Hello Hello

 

to

 

Hello

hello

Hello

 

In other words, I want a lot of email address that are all squashed together (with spaces)and I want it all in one straight line going down

[Exacto-Be]

I made an excel file for this ...

 

it's not perfect since it will only respond to either "hello" or "Hello"

 

but it might already be a good start

 

http://www.2shared.com/file/lRtWRh96/garfields_problem.html

it's a "Microsoft Office Excel 2007-werkmap (.xlsx) file"

 

B1-cell : here you place the tekst u want to split up

B2-cell: here you place the word u want search on ... hello ... Hello ... whatever you want (just keep in mind that the use of capitals makes a huge difference)

 

This is the closest i could get

[Guest barackobama]

ok it works, that's perfect, what do I do now... lol? I have a lot of emails I need to make like that!

[Guest barackobama]

ok here is another example...

 

hello@aol.com dffgfg@aol.com werer@hotmail.com

 

^ like that I have lots of emails, all I wanted to do is make it so everyone goes in a line like

 

hello@aol.com

dffgfg@aol.co

werer@hotmail.com

 

I have around 800 emails to do this with..

[Exacto-Be]

oh, i see now ... gimme some time i'll see what i can do for this

[Exacto-Be]

i've gotten myself a headache by trying to do 2 things at the same time ...

 

Seeing to the fact that u're only using emails every part u needs is getting split up by a space ...

 

I made some little changes in the file ... here's the newest http://www.2shared.com/file/WasuohMZ/garfields_problem.html

All u should do in this file is to place all the e-mailadresses in B1

 

I did this with ur example and that worked out pretty well ...

 

- What u have to type in B2 now is the part that comes in between the emails ...

Example1: Exact@aol.com Chill@dsd.com derp@aol.com --> u need a " " (space)

Example2: Exact@aol.com,Chill@dsd.com,derp@aol.com --> u need a "," (comma)