Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 6th 13, 07:12 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 5
Thumbs up Need Opinion

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
Attached Files
File Type: zip Files.zip (9.7 KB, 134 views)

  #2   Report Post  
Old August 6th 13, 08:15 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,607
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Project - Second opinion please! Danny Excel Worksheet Functions 11 September 17th 07 11:03 PM
opinion on code / formula reiult Gary Keramidas Excel Programming 0 July 20th 07 06:19 AM
Need Opinion on Toolbar Creation surfbored Excel Programming 2 October 9th 06 10:19 PM
Your opinion CBrausa Excel Discussion (Misc queries) 1 May 18th 06 07:55 PM
Synchronizer: in my opinion, best diff tool for excel. [email protected] Excel Discussion (Misc queries) 0 June 23rd 05 03:44 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017