Lookup Formula

[juliehmac]

Hello,

I have a column of data with: Last name,Company Name-First Name

I wanted to create a lookup formula to return only the company name in the adjacent cell.

Does anyone know how I would do this?
Thank you

 

[ukmikeb]

Hi

Welcome to the MrExcel Forum.

Try in B2:-

=MID(A2,FIND(",",A2)+1,FIND("-",A2,FIND(",",A2))-FIND(",",A2)-1)

nb This will work even if the Last Name is hyphenated but will not work if the Company Name also has a hyphen

hth

 

[juliehmac]

It worked perfectly, thank you!