Hi All,

I have a list of data in excel, which i want them in separate cell.

Example:
Cell A1:*Iowa Department Of Transportation (crossroa, 0103, Current) (800 Lincoln Way Ames, LA 50010)

I'm expecting the output in another cell like
B1 - Iowa Department of Transportation
C1 - crossroa, 0103, Current
D1 - 800 Lincoln Way Ames, LA 50010

Attached please find the excel sheet which contains whole data for your reference.

Regards,
Asrar Ayub