View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steveg160 steveg160 is offline
external usenet poster
 
Posts: 1
Default reversing text within cells

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.