Word F&R: Replace with new line 1

[gmail2]

I've been trying to find out how to do this for ages but I can't find anything - so I'm gonna have to come to the experts !! What I want to do is replace a certain character (in this case it's with a new line. Because I have a long line of e-mail addresses separated by ; which I want to put onto separate lines. I've tried looking up the ASCII code for a new line but I can't find it. Anybody got any ideas how I can do this? I would have thought it'd be pretty simple ... but obviously not !!

Irish Poetry - Karen O'Connor
Get your Irish Poetry Published
Garten und Landschaftsbau

 

[HarleyQuinn]

Depending on which version of Word you are using this achievable using the normal find and replace dialogue.

I'm using Word 2003 and in my find&replace dialog there is a drop down button captioned "More", click that go to "Special" and select "Manual Line Break". That will split the string as you require (as long as you specify that its' ";" that you want to replace )

I'm not sure if this is a feature of earlier version's of Word.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

Thanks for the star

Just realised that this can also be achieved by bypassing the "More" button step and just using a replace keyword of ^l (the l is a lower case L).

Cheers

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[gmail2]

sorry - was just about to reply. I'm using word 2003 so it was perfect for what I wanted - thanks, that's a BIG help. KInd of weird that ^l represents a lie break tho !!

Irish Poetry - Karen O'Connor
Get your Irish Poetry Published
Garten und Landschaftsbau

 

[TonyJollans]

It is the same in all versions of Word.

^l gives a manual line break (equivalent to pressing Shift+Enter)

^p gives a paragraph break (equivalent to pressing Enter)

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[