I have a list of positions + company names. Example: "senior manager at xxx company".
I need to separate the information that comes after the "at", so I can get only the company name. Which formula can I use to do that?
Many thanks in advance, Ana
B1 = left(A1,find(" at ",A1)-1)
C1 = mid(A1,find(" at ",A1)+3,len(A1))
Assuming the data is in cell A1, you can enter the following formula in cell B1:
=MID(A1,FIND("at",A1)+2,99)
if you are not a big fan of formulae enter the first company name manually in the adjacent column here cell B2 and drag as you would while filling a series but this time just click flash fill instead of the default fill series
Screenprint is available for your reference. This option works with Excel 2013 onwards.
Final Output after Flash Fill
at
?
May 29, 2020 at 5:35
=RIGHT(A1,LEN(A1)-FIND("at ",A1)-1)
& fill down.