Customer name and address on the same cell

[Tommentions]

Hello, I need help please.  I have a list of customer names and address in the same cell.  How do I separate them.  

Tom

[#2]

Hi @Tommentions 

Look at Text to Columns (in Excel Data tab)