Do some Excel Formula or Macro

In Progress Posted Aug 30, 2015 Paid on delivery
In Progress

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 .

Data Entry Data Processing Excel Powerpoint Word

Project ID: #8367098

About the project

2 proposals Remote project Active Sep 1, 2015

Awarded to:

Nosek

Nie złożono jeszcze oferty.

$5 USD / hour
(5 Reviews)
2.0

2 freelancers are bidding on average $6/hour for this job

akshay175

I can do this in a couple of minutes............ Lets discuss and start this asap....................

$15 USD / hour
(13 Reviews)
4.3
arunkc

A proposal has not yet been provided

$6 USD / hour
(0 Reviews)
0.0