how do I convert cell 'Street,#' to '# Street' these are addresse

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
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
Click to expand...


=RIGHT(A1,LEN(A1)-FIND(",",A1))&" "&LEFT(A1,FIND(",",A1)-1)


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert street address to zip code 1
Seperate Name, Street Address & City, State Zip 5
Extract street number (foreign address) 7
How do I parse an address field to separate street # from street n 1
How do I sorty by addresses, ignoring number, using street name 1
separating street numbers and street names 4
How do I parse street address with 4 parts #,Dir,Street,Type 1
Coding Question 3

Back
Top