reversing text within cells

S

steveg160

i am working with a list of addresses in my spreadsheet and i want to reverse
the street numbers and street names. For example my adresses read like this
"25 main street" i want them to read like this "main street 25" is there
any way to reverse the adresses in multiple cells without re tying each
adress in each cell.
 
L

Luke M

If address is in A2
=RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
Copy down as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top