Paste a representative sample of your data into a post so's we can have a look.


Gord Dibben MS Excel MVP

On Sun, 2 Dec 2007 12:20:01 -0800, jr0410
wrote:

I have a column of numbers. Some numbers vary in the number of characters
and some are strickly numbers; others are a mix of numbers and letters. I
would like to replace those numbers with the same numbers but with
parenthesis around each of them. How do I do that?