Hi Gemini,
Couple of points you may wish to consider.
1) > Hi LMR! The solution posted by MartinW will work for you.
Well that is still a bit unsure, the OP's second post is a bit vague as
to the way their data is setup. We'll have to wait until they get back
to us on that count.
2) > If you need a space after the ")", then use ") " (there's a space
included) rather than the ")".
The formula I posted has a space in it. When using formulae from the
newsgroup it is much better to copy and paste from the post
rather than retyping it. It stops you missing the little details.
3) > Click in cell C1 and then do a Paste Special,
selecting Values. That'll copy all the values in col B into col C,
No need to use column C. You can just Paste Special>Values
on column B straight over the top of itself.
Regards
Martin