LinkBack URL
About LinkBacks
What function will take a number like 10078213 and give me the 2nd, 5th, 6th, & 8th number in another column?
Example... 10078213 = 0823
Thank you in advance for any and all help!!!!
What function will take a number like 10078213 and give me the 2nd, 5th, 6th, & 8th number in another column?
Example... 10078213 = 0823
Thank you in advance for any and all help!!!!
=mid(a1,2,1)&mid(a1,5,1)&mid(a1,6,1)&mid(a1,8,1)
=mid(a2,2,1)&mid(a2,5,2)&mid(a2,8,1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-gene...th-number.html
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks