Hello!
I was hoping somebody here could help me with certain problem.
I have database in excel format with over 4000 rows.
The first column contains a code in a form A1111A. I would like to break it down so that the first column would be A, second 1111, third A.
Graphically it looks something like this:
the way it is.png
and I want it like this:
the way i want it.png
Is this possible?
Thank you SO MUCH!!!!
Good afternoon Maui_High
Will this code always be in the format 1 alpha, 4 numeric, 1 alpha?
If your source date is in row D then formulae like this would be OK :
=LEFT(D1,1)
=MID(D1,2,4)
=RIGHT(D1,1)
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thank you dominicb, you're a life saver!!
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks