EDIT: Attached the missing file.
Hi,
I have a cell which has address and unit numbers in A1 (e.g - 405 Havelock Road #05-01, 169633). I am trying to find the unit number which is between the character # and ,
I am using the formula =MID(LEFT(A1,FIND(",",A1)-1),FIND("#",A1)+1,LEN(A1)) and it works great but the problem is with the address which has multiple (,) before the # like - 68 Orchard Road, Plaza Singapura #B2-49, 238839.
Is there a way I can use an "IF" formula or some other way to ignore all the comma before the #?
I have attached a sample file for your understanding.
Thanks,
Bookmarks