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

Extract data to the right of the last comma in a cell
 

try this adjusted array-formula, supplied by Tom Ogilvy on Apr. 28,
2001:

=RIGHT(A1,LEN(A1)-MAX(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=",",R OW
(INDIRECT("1:"&LEN(A1))),)))

HIH


On 12 Sty, 15:37, Huber57 wrote:
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

Extract data to the right of the last comma in a cell
 

Perfect! Thanks much.

"Jarek Kujawa" wrote:

try this adjusted array-formula, supplied by Tom Ogilvy on Apr. 28,
2001:

=RIGHT(A1,LEN(A1)-MAX(IF(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=",",R OW
(INDIRECT("1:"&LEN(A1))),)))

HIH


On 12 Sty, 15:37, Huber57 wrote:
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

Extract data to the right of the last comma in a cell
 

Here's a regular (non array) formula solution to extract data to the
right of the last comma in a cell:

=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1,",","*",LEN(A1)-LEN(SUBSTITUTE
(A1,",","")))))