About Us

Jarek Kujawa[_2_]

excellent!
;-)

On 17 Sty, 14:24, Dave Peterson wrote:
One more.

Copy the all the data into two columns (identical columns when you're done).

Select the first column
ctrl-h (replace)
what: *_(* * * * * * * * (space character, open paren, asterisk)
with: *(leave blank)
replace all
This will remove the (####) from the first column.

Select the second column
ctrl-h (replace)
what: **( * * * * * * *(open paren, asterisk)
with: *(leave blank)
replace all
This will remove the name.

Select the second column
ctrl-h (replace)
what: *) * * * * * * *(close paren)
with: *(leave blank)
replace all
This will remove the closing paren

Stan in South Africa wrote:

Using Vista, Excel 2007

I have the following:
In A1 - 'Bill Smith (2468)'
In A2 - 'James Sinclair (659873)'
and so on to A350, with names of various lengths and numbers containing a
different number of digits in parenthesis.

I require, in text format:
In B1 - 'Bill Smith' *In C1 '(2468)'
In B2 - 'James Sinclair' In C2 '(659873)'
and so on to row 350.

Any advice will be appreciated.

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to extract just text from cells	Access Joe	Excel Worksheet Functions	4	April 29th 08 09:06 PM
Tying to extract all data from a pivot pulling from external data	Ted Urban	Excel Discussion (Misc queries)	3	September 14th 07 10:50 AM
Extract numbers from cells	Orf Bartrop	New Users to Excel	5	December 17th 06 08:04 AM
extract data from a range of cells in rows or columns when a date.	Dartyon	Excel Worksheet Functions	0	February 24th 05 10:37 PM
extract data from cells	Nicole L.	Excel Worksheet Functions	2	February 2nd 05 08:54 PM

Menu

About Us