LinkBack URL
About LinkBacks
I have a spreadsheet that includes Canadian postal codes which, when correctly formatted are "XXX XXX". In my sheet they are all formatted "XXXXXX". How do I tell excel to add a space after the third character?
I have a spreadsheet that includes Canadian postal codes which, when correctly formatted are "XXX XXX". In my sheet they are all formatted "XXXXXX". How do I tell excel to add a space after the third character?
You could do that with a formula in another column, e.g. if postcodes start at A2 then use this formula in B2 copied down
=REPLACE(A2,4,0," ")
Audere est facere
in another column enter formula like:
=REPLACE(A2,4,0," ") where A2 contains a postal code entry.... and copy down for others.
You can then copy and paste special >> values over the original and delete the formula column.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
Thread moved to General forum.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks