Can I separate a full address with commas in one cell with commas? - TechRepublic
Question
April 7, 2010 at 02:53 AM
bmortlakes

Can I separate a full address with commas in one cell with commas?

by bmortlakes . Updated 16 years, 2 months ago

I am working with a large excel list of addresses. The addresses are the format below in one cell
‘123 new street, Finchley, London, N1 4DX’
Can I reformat these to be on different rows but in the same cell? For example
123 New Street
Finchley
London
N1 4DX

This discussion is locked

All Comments