Question Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by gazskeltz

Hi, although the above will work, it needs typing. If you have a whole list of addresses, this will be tedious. Instead, try the following.

1. Select all the cells you want to convert.
2. Edit/Replace
3.In the Find What box, type a comma and a space.
4. In the Replace with box hold down the alt key and type 010 (you won't see anything there...)
5. Hit replace all.

Hope this helps

Gaz

This discussion is closed to new replies.