asked on

Search and Replace in Excel

I need to replace commas "," with newlines in Excel. There could be 1000 of these (in specific columns).

I can't find the mechanism for doing this via the Find & Replace. I've seen things like Ctrl-Shift-j (but that doesn't work) as the newline.

Subodh Tiwari (Neeraj)

That should work. Make sure Wrap Text is enabled.

Norie

Gene

CTRL+SHIFT+J works for me, how did it not work for you?

Was anything replaced?

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

AlphaLolz

ASKER

I don't know what you mean wrap text is enabled. I have text on multiple rows all over this workbook. There's no option for this in the Find & Replace.

Norie

Wrap Text is an Alignment setting and if you don't have it set then it may appear that the values in cells are all on one line even if there are line breaks.

AlphaLolz

ASKER

Thanks for the help. I knew there might be something like this available.

AlphaLolz

ASKER

Alignment wasn't an issue and the use of the alt and numeric keypad worked.

Martin Liss

You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017