moving data within a column

[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

 

[Frank Kabel]

Hi
one way: use 'Data - Text to columns