Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 12, 02:33 AM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default Need a little help!

Hi guys,

I'm not exactly new to excel but what I'm going to ask could be considered as a newbie question.

So let's get things started.

Lets say I have something like :

Code:
 
Mr Patrick Yong (Chief Executive Officer)
Mr Yoshiro Furumi (Managing Director)
And the list goes on.

What I want know is, how do I remove the name leaving only their job title behind?

I actually want it to be replaced like below :

Code:
Chief Executive Officer 
Managing Director
I have tried using find and replace where I find " ? (*) " and replace with "*". However, I do not think it's just possible as the whole thing would be replaced with * instead of the wildcard that is defined.

A little help guys?

  #2   Report Post  
Old May 30th 12, 03:06 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Need a little help!

Select the column.

DataText to ColumnsDelimited byOther(

NextNextDo not Import Column(skip)Finish

Now editreplace the remaining ) with nothing.


Gord

On Wed, 30 May 2012 01:33:55 +0000, Xeralize
wrote:


Hi guys,

I'm not exactly new to excel but what I'm going to ask could be
considered as a newbie question.

So let's get things started.

Lets say I have something like :


Code:
--------------------

Mr Patrick Yong (Chief Executive Officer)
Mr Yoshiro Furumi (Managing Director)

--------------------


And the list goes on.

What I want know is, how do I remove the name leaving only their job
title behind?

I actually want it to be replaced like below :


Code:
--------------------

Chief Executive Officer
Managing Director

--------------------


I have tried using find and replace where I find " ? (*) " and replace
with "*". However, I do not think it's just possible as the whole thing
would be replaced with * instead of the wildcard that is defined.

A little help guys?

  #3   Report Post  
Old May 30th 12, 07:12 AM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Default

Figured out the solution using a macro.

Another problem that I'm facing is I would like to extract postcodes from a line of address and all postcodes have 5 digits.

Hence from a small part from the worksheet:

Code:
 
Bukit Jalil Integrated Business Park, Mukim Petaling 58200 Kuala Lumpur
Kawasan Perusahaan Bangi, 43650 Bangi Selangor Darul Ehsan
No 2, Jalan Kuning, Taman Pelangi, 80400 Johor Bahru Johor Darul Takzim
Would like it to just appear as:

Code:
58200
43650
80400
Is there any wildcard for number only? I don't think it is possible to use a formula considering the position of the postcode varies from one cell to another. Any suggestions?


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



All times are GMT +1. The time now is 04:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017