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
Bookmarks