Finding certain character in string

  • Thread starter Thread starter Bob V
  • Start date Start date
B

Bob V

I have item names that have an 'X' embedded which could be in different
places. Is there a formula I can use to find those items?
For example: CBS88XSDS and CC86XSDS.

TIA,
Bob
 
Bob V said:
I have item names that have an 'X' embedded which could be in different
places. Is there a formula I can use to find those items?
For example: CBS88XSDS and CC86XSDS.

TIA,
Bob
Click to expand...
If the above can be done, is there a way to find & remove a particular
character. In the example above CBS88XSDS would be in one cell, and then I
would like to have CBS88SDS appear in the adjacent cell.
 
Once found, then what?

With CBS88XSDS in A1

Enter in B1 =SEARCH("X",A1)

Will return 6 to give you position of X in string.


Gord Dibben MS Excel MVP
 
Back
Top