Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reversing text within cells
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reversing text | Excel Discussion (Misc queries) | |||
Reversing Text in cells | Excel Discussion (Misc queries) | |||
REVERSING CELLS? | Excel Discussion (Misc queries) | |||
Reversing characters of cells | Excel Discussion (Misc queries) | |||
Reversing First & Last Name | Excel Worksheet Functions |