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

Luke M
*Remember to click "yes" if this post helped you!*


"steveg160" wrote:

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.