Hi,
I have the formulas in the following format:
They return result along the lines of
Smith, John
I need the formula to only return the value before comma (Smith) but struggle to marry the above formula with the likes of
Is it even possible or I have to add helper column?
I have the formulas in the following format:
Excel Formula:
=VLOOKUP(K3,IWRS003!A2:B800,2,FALSE)
Smith, John
I need the formula to only return the value before comma (Smith) but struggle to marry the above formula with the likes of
Excel Formula:
=LEFT(A1,(FIND(",",A1,1)-1))