I have a column of about 150 cells that have data in them, all in this format:
AAAA######-#
A - letter
# - number
I need to reformat the entire column and have a space " " between the letters and numbers.
AAAA ######-#
Any ideas of an easy was to go about this?
Are there always 4 letters, followed by the numbers?
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.
yes, every cell has the exact format right now
Then, try:
=Left(A1,4)&" "&Mid(A1,5,255)
what does the 255 stand for?
255 characters max... which you will probably never have...so it takes the balance of characters in the field.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks