Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert cell 'Street,#' to '# Street' these are addresse
I have an extensive list of addresses -- provided format is 'streetname,###'
(notice comma), I need addresses in format '### streetname' (notice space). An example would be 'Washington,1909' and desired outcome would be '1909 Washington' I'd appreciate any suggestions for conversion script. Thanx RL |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert cell 'Street,#' to '# Street' these are addresse
First you create an empty column to the right of your text. Then Data, Text
To Columns and follow delimited with coma. This will split your words from your numbers. At this time you now have two columns. Then in an ALL new 3rd column to the right you CONCATENATE both columns. HTH Gilles "Closing hyperlinked wookbooks upon exit" icrosoft.com wrote in message ... I have an extensive list of addresses -- provided format is 'streetname,###' (notice comma), I need addresses in format '### streetname' (notice space). An example would be 'Washington,1909' and desired outcome would be '1909 Washington' I'd appreciate any suggestions for conversion script. Thanx RL |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert cell 'Street,#' to '# Street' these are addresse
On Sat, 29 Apr 2006 18:35:02 -0700, Closing hyperlinked wookbooks upon exit
icrosoft.com wrote: I have an extensive list of addresses -- provided format is 'streetname,###' (notice comma), I need addresses in format '### streetname' (notice space). An example would be 'Washington,1909' and desired outcome would be '1909 Washington' I'd appreciate any suggestions for conversion script. Thanx RL =RIGHT(A1,LEN(A1)-FIND(",",A1))&" "&LEFT(A1,FIND(",",A1)-1) --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert cell 'Street,#' to '# Street' these are addresse
Here's another option =MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=537533 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
resetting last cell | Excel Discussion (Misc queries) | |||
convert number in cell to text in another cell | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |