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.
LVL 1
Gene KlamerusTechnical ArchitectAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
In the Replace tab of Find and Replace, hold down the <ALT> key and type 0010 on the numeric keypad.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
That should work. Make sure Wrap Text is enabled.
0
 
NorieVBA ExpertCommented:
Gene

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

Was anything replaced?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Gene KlamerusTechnical ArchitectAuthor Commented:
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.
0
 
NorieVBA ExpertCommented:
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.
0
 
Gene KlamerusTechnical ArchitectAuthor Commented:
Thanks for the help.  I knew there might be something like this available.
0
 
Gene KlamerusTechnical ArchitectAuthor Commented:
Alignment wasn't an issue and the use of the alt and numeric keypad worked.
0
 
Martin LissOlder than dirtCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.