moving data within a column
 

I have an old EXCEL spreadsheet with the first column containing numbers ie:
(2) 04-410, what I need to do is create a fromula to move the (2) the number
in parathensis to the right side of the column . this is so I can sort.

Thank you,
K. Tremblay

Hi
one way: use 'Data - Text to columns

--
Regards
Frank Kabel
Frankfurt, Germany

"Kathy" schrieb im Newsbeitrag
...
I have an old EXCEL spreadsheet with the first column containing
numbers ie:
(2) 04-410, what I need to do is create a fromula to move the (2) the
number
in parathensis to the right side of the column . this is so I can
sort.

Thank you,
K. Tremblay