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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks