How to find cells ending with numbers and adding something to those cells

[jilaba]

Ref. Attachment.

Column A has names. Victor + 1, Mary + 2, Jennie. I want them to be Victor + 1 person, Mary + 2 persons, Jennie respectively in column B. ie need to identify the cells in column A, ending with (singular / plural) numbers or alphabets and act accordingly.

Thanks

[PaulM100]

One way:=IF(ISNUMBER(VALUE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255)))),A2&IF(VALUE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255)))>1," Persons"," Person"),A2)

[jilaba]

One way:=IF(ISNUMBER(VALUE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255)))),A2&IF(VALUE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255)))>1," Persons"," Person"),A2)

Thanks, it solved. Prompt reply.

[KOKOSEK]

Excel 2016 (Windows) 32 bit

	A	B
1	Name	Results
2	Victor + 1	Victor + 1 Person
3	Mary + 2	Mary + 2 Persons
4	Jennie	Jennie

	A	B
1	Name	Results
2	Victor + 1	=IFERROR(IF(FIND("+",A2),A2&" Person"&IF(RIGHT(TRIM(A2),1)*1>1,"s",""),""),A2)
3	Mary + 2	=IFERROR(IF(FIND("+",A3),A3&" Person"&IF(RIGHT(TRIM(A3),1)*1>1,"s",""),""),A3)
4	Jennie	=IFERROR(IF(FIND("+",A4),A4&" Person"&IF(RIGHT(TRIM(A4),1)*1>1,"s",""),""),A4)

[queuesef]

Put this formula in C2 =IF(ISNUMBER(VALUE(RIGHT(A2,1))),+A2&" Person",A2) - the formula is looking at if the last digit is numeric, if it is, it adds " Persons" to your original value. This will not make singular. It's a start

[jilaba]

Put this formula in C2 =IF(ISNUMBER(VALUE(RIGHT(A2,1))),+A2&" Person",A2) - the formula is looking at if the last digit is numeric, if it is, it adds " Persons" to your original value. This will not make singular. It's a start

Thanks, anyway i need singular / plural specific.

[jilaba]

Excel 2016 (Windows) 32 bit

	A	B
1	Name	Results
2	Victor + 1	Victor + 1 Person
3	Mary + 2	Mary + 2 Persons
4	Jennie	Jennie

	A	B
1	Name	Results
2	Victor + 1	=IFERROR(IF(FIND("+",A2),A2&" Person"&IF(RIGHT(TRIM(A2),1)*1>1,"s",""),""),A2)
3	Mary + 2	=IFERROR(IF(FIND("+",A3),A3&" Person"&IF(RIGHT(TRIM(A3),1)*1>1,"s",""),""),A3)
4	Jennie	=IFERROR(IF(FIND("+",A4),A4&" Person"&IF(RIGHT(TRIM(A4),1)*1>1,"s",""),""),A4)

Thanks, But sometimes it is not returning the names without numbers. Anyway it was solved.

[jilaba]

Thanks all, it was solved by first answer itself.