Do some Excel Formula or Macro

Hello

This is simple excel work for experts .

I have name list .

I need to split this sentence into two part from "at" .

For example :

"Partner at Hughes Pittman & Gupton LLP"

I need to split above sentence into two cell as bellow from "at"

"Partner" in one cell and " Hughes Pittman & Gupton LLP" another cell

I have about 1 million similar as sentence .

I need some one who can write a simple macro or Formula to do this .

Please check attached file .

Datainmatning Databehandling Excel Powerpoint Word

Projekt-id: #8367098

About the project