Get instant live expert help on how to separate address in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

need to separate address fields, i was able to separate the state and zip but having trouble with the city
Solved by G. A. in 15 mins
Hi there, In column A, in separate cells I have a business title, below is the address, below that is the phone number and again below is the email address. How can I transfer each section of data to a corresponding column?
Solved by S. C. in 18 mins
I NEED TO SEPARATE POSTCODES FROM ADDRESS INTO NEW COLUMN SO THAT I CAN ARRANGE IN POSTCODE ORDER
Solved by G. U. in 27 mins
I am trying to combine email address added in a column in separate rows, into one field separated by semicolon. Which is the best command to do this?
Solved by S. W. in 13 mins
I need to separate a column with address data into separate columns for city, state, zip, and street. There are no commas and the data seems to be separated different depending on cell
Solved by D. C. in 21 mins