reversing text within cells

  • Thread starter Thread starter steveg160
  • Start date Start date
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.
 
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

Back
Top