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:
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 A little help guys? |
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? |
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:
Code:
58200 |
All times are GMT +1. The time now is 08:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com