Formulae to extract cell value and create new column for the extracted value

[harman83]

Hi Friends

I want to extract Cell values after "at" and paste that into new column.

Example
Col A
Quantitative Analyst at Manulife Financial

End Result should be
Col A Col B
Quantitative Analyst Manulife Financial

Please suggest how this can be done.

Thanks Cell Value.png

[AlKey]

Try this formula

in A3 and pull it to the right

=TRIM(MID(SUBSTITUTE($A1," at ",REPT(" ",99)),99*(COLUMNS($A:A)-1)+1,99))

Data Range

	A	B
1	Quantitative Analyst at Manulife Financial
2
3	Quantitative Analyst	Manulife Financial

[harman83]

Thankyou...It worked....Thanks