Many thanks guys - all of these work great!

"starguy" wrote in
message ...

select the range your data resides in then
press Ctrl+H
in Find What: press a space then write this (*)
in Replace with: leave it blank
press Replace All
you are done.
hope this will serve your purpose.

Terry Bennett Wrote:
I have a lenghty list of data all within one column (ie; rows 1 -
2000).
All of the data consists of a branch name followed by some figures in
brackets, ie:

Southampton (12345-654)

Is there a way that I can 'trim' the data to remove everything within
the
brackets, including the brackets themselves?


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=562032