Format: enclose content of cells in parantheses

A

awkwardpause101

Hi there,

Is there an easy way to automatically format the contents of the cell
in any given column so that the content (text and numbers) are
enclosed in parentheses?

So, for example, 'random info' becomes ('random info')?

Thanks,

lamasoft
 
D

Dave Peterson

Maybe you could use a column with formulas like:

=if(a1="","","("&a1&")")
And copy down the column.

Then select that column
Edit|copy
edit|Paste special|values

and delete the original column.
 
Top