Thread: Need Opinion
View Single Post
  #2   Report Post  
Old August 6th 13, 08:15 AM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,673
Default Need Opinion

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2