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.
 
Back
Top