Replace comma with new line characters

**OahuBrew** · 07-12-2013, 02:57 PM

Hi all I have a string in a column like so surgery, radiology, behavior health, ambulatory

I need to remove the commas and and replace with new line and store this in the same single cell so it looks like

surgery
radiology
behavior health
ambulatory

Thank you for any advice much appreciated...

**Jonmo1** · 07-12-2013, 03:01 PM

Use the Find/Replace tool in excel..

Highlight all the cells you want to do this on.
go to the Find/Replace tool
Find what: ", " <--comma space without the qotes
Replace with: Hold the ALT Key, and type 010 on the number keypad
Replace All

Hope that helps.

**tigeravatar** · 07-12-2013, 03:03 PM

OahuBrew,

Welcome to the forum!
You can use this formula, then make sure "Wrap Text" is enabled:
=SUBSTITUTE(A1,", ",CHAR(10))

Afterwards, if you like, you can copy -> paste special -> values