I want to know how to extract a desired digit/digits from the data in the cell
Example:
Row1: A345BS1003
Row2: A35BS1007
Row3: BS1007A335
Row4: 3500A354BS
How can I set formula to extract the digits "BS" among the above 4 cells?
Kelvin
I want to know how to extract a desired digit/digits from the data in the cell
Example:
Row1: A345BS1003
Row2: A35BS1007
Row3: BS1007A335
Row4: 3500A354BS
How can I set formula to extract the digits "BS" among the above 4 cells?
Kelvin
Since this is random all over the place, perhaps you'd rather just test to see if "BS" is in the string anywhere? If so, show "BS", if not...show blank?
If so, this would do that:
=IF(ISNUMBER(SEARCH("*bs*",A1)),"BS","")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Perfect solution, thanks!!!
Great!
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks