Find/Replace one line with multiple lines

**ugonow** · 03-13-2013, 02:03 PM

I have one line that I want to replace with multiple lines. Is there a way to do a global find/replace with multiple lines? I have around 1,700 lines to replace and it will take too long manually. I appreciate any help or suggestions!

Line to be replace...

(COUNTOUR 1)

To be replaced with...

W1
GO4 X.2

Thanks,

Rodney

**manoj.0790** · 03-13-2013, 03:10 PM

It would be great if you could attach a sample workbook.

Originally Posted by ugonow

I have one line that I want to replace with multiple lines. Is there a way to do a global find/replace with multiple lines? I have around 1,700 lines to replace and it will take too long manually. I appreciate any help or suggestions!

Line to be replace...

(COUNTOUR 1)

To be replaced with...

W1
GO4 X.2

Thanks,

Rodney

**manoj.0790** · 03-13-2013, 03:14 PM

You may try find and replace advanced option. please have a look on the attached image .

You can get that pop by pressing Ctrl+H

Find option.jpg

Originally Posted by ugonow

I have one line that I want to replace with multiple lines. Is there a way to do a global find/replace with multiple lines? I have around 1,700 lines to replace and it will take too long manually. I appreciate any help or suggestions!

Line to be replace...

(COUNTOUR 1)

To be replaced with...

W1
GO4 X.2

Thanks,

Rodney

**ugonow** · 03-13-2013, 03:39 PM

What I posted is all that is needed. The whole file won't help you. It's just a find and replace. Besides, I know you can attach a file, but I don't see where.

**jindon** · 03-13-2013, 11:59 PM

1) Select the cells that to be replaced.
2) Find and Replace
3) Find what (COUNTOUR 1), Replace ="W1"&chr(10)&"GO4 X.2"
4) Change cell format to WrapText.