Extract data to the right of the last comma in a cell
TO all:
I have a cell that contains the following data:
SMD,CAP,TANT,10UF,16V/20V,10%/20%,3528
I need to return just the 3528 at the end of it. It is not always 4
characters (otherwise I would use=RIGHT(A1,4).
Any help is greatly appreciated!
Sincerely,
Doug
|