Art, Music, and Creative Writing homework help. I am trying to import a text file into excel and then concatenate the info. I am close but I cannot figure out how to separate the state from the zip code when it is written like:Bob Jones 123 Sesame St Walla Walla, WA 12345123-456-7890I can get everything on one line and use the trim function to get rid of the spaces before the address and city/state/zip line…but I am not sure how to separate the State and Zip so they will be in their own column. This is why my data looks like: Bob Jones,123 Sesame St,Walla Walla WA 12345,123-456-7890. My current formula is: =CONCATENATE(TRIM(A1),”,”,TRIM(A2),”,”,TRIM(A3),”,”,TRIM(A4))Any suggestions?
Our Company
-
- eliteessaypool will be listed as ‘Writing Help’ on your bank statement.