Thread: how do I convert cell 'Street,#' to '# Street' these are addresse
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Closing hyperlinked wookbooks upon exit
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote