Char(10)

[Obied70]

Hi Geniuses,
I need some help inserting line breaks where a cell contains a certain word. For example the address line "100 East King Way Suite 100" needs to have a line break so that "Suite 100" is on another line in the same cell. I would do it manually but I have ~40,000 rows to go through so using a formula/vba is a much better option. Thanks for your help!

 

[Obied70]

Re: Char(10) Help

These were all imported from a list provided by a vendor so unfortunately I have to work with what I've got but thanks to you it's much easier to manage.