Hi, Sir.
Every time our workers will enter several numbers in the excel sheet cell, they may enter every number randomly. I just want to use formula to find the only series number start from 91SE in that cell.
How should I do to get my result?
Hi, Sir.
Every time our workers will enter several numbers in the excel sheet cell, they may enter every number randomly. I just want to use formula to find the only series number start from 91SE in that cell.
How should I do to get my result?
if you find it what is the result i mean color that cell or get the value beside it?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi,Sir, i want to find the whole number start from 91SE.
may be whole number is 91SE23487583.
I just want to find this number. furthermore, I need to this number to be displayed at another work sheet.
I mean I find this number from worksheet1, and I could use formula to find it and auto get number in sheet 2
you can do it like this
in sheet 2
Formula:Please Login or Register to view this content.
or if A cell houses 91SE say B1
Formula:Please Login or Register to view this content.
Or, if you like 'em short; put this in, oh, say B2 and copy down...
Formula:Please Login or Register to view this content.
Thank you, problem solved~!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks