Enter new line in cell after searched text

[mrmrva]

I have a column with about 2000 rows with text that is not formatted correctly, email addresses that are concatenated, so I need a way to enter new line in a cell after searched text

Example:
search term is *.rs

Cell A1 content:

someText.rsAnotherText

Cell A1 after operation:

someText.rs AnotherText

Any help appreciated

[LJMetzger]

Hi mrmrva,

a. Find all occurrences of .rs using the Find All CommandButton in the 'Find and Replace' UserForm.
b. Go to the Replace Page.
c. In the 'Replace with:' window, type in .rs, then hold down the Alt Key and type 010 (ZERO ONE ZERO) on the numeric Keypad. 010 is the Linefeed ASCII character.
d. Select the 'Replace All' CommandButton.
e. Done

My solution is thanks to Andrew Poulsom at http://www.mrexcel.com/forum/excel-q...e-newline.html

Lewis

[mrmrva]

OMG, of course
I was thinking I needed VBA code for something like this, didn't occur to me simple search and replace could be used.

Thanks for quick reply.
Regards,
Petar