moving data within a column

K

Kathy

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
 
Top