Need a little help!

X

Xeralize

Hi guys,

I'm not exactly new to excel but what I'm going to ask could b
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 jo
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 replac
with "*". However, I do not think it's just possible as the whole thin
would be replaced with * instead of the wildcard that is defined.

A little help guys
 
G

Gord Dibben

Select the column.

Data>Text to Columns>Delimited by>Other>(

Next>Next>Do not Import Column(skip)>Finish

Now edit>replace the remaining ) with nothing.


Gord
 
X

Xeralize

Figured out the solution using a macro.

Another problem that I'm facing is I would like to extract postcode
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 t
use a formula considering the position of the postcode varies from on
cell to another. Any suggestions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top