Is there a way I can format a mailing address into different cells. For example this text is in one cell. 6136 hutchison montreal quebec h2v 4c2 How can I get the street address: 6136 hutchison city: Montreal state: Quebec and zip code: H2V 4C2 into different cells? Also sometime Montreal is written mtl.
Thank you.
Hi,
This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks