I have three columns:
Street Name
Type
Direction
The "Type" column has a large amount of spacing in it and Trim does not work. Also =SUBSTITUTE(b2,CHAR(160),"") does not work.
Need to combine columns into one column. see attachment
Thanks
I have three columns:
Street Name
Type
Direction
The "Type" column has a large amount of spacing in it and Trim does not work. Also =SUBSTITUTE(b2,CHAR(160),"") does not work.
Need to combine columns into one column. see attachment
Thanks
Try this:
=C3&" "&TRIM(A3)&" "&B3
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try...
=TRIM(CLEAN(SUBSTITUTE(B2,CHAR(160)," ")))
Cleaning "Dirty" Data
Last edited by jeffreybrown; 01-13-2018 at 01:11 PM.
HTH
Regards, Jeff
ALIGW
Yes, it worked. Thank you very much.
You're welcome!
Based on your desired output cell H11 should have a result of E 12TH ST. To fix this try this one
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks