Need Opinion

[Asrar Ayub]

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 you
reference.

Regards,
Asrar Ayu

+-------------------------------------------------------------------
|Filename: Files.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=898
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Asrar,

Am Tue, 6 Aug 2013 07:12:19 +0100 schrieb Asrar Ayub:

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

select column A => TexttoColumns => Delimited => Delimiter is (
Target cell is B1
Then run Replace => Find what = ) => Replace with is nothing


Regards
Claus B.