reverse/manipulate order of numbers?

[Guest]

I need to have to control of numbers in a list of numbers and puncuation,
keeping the solution as numbers & not a new, text string.

List:

01(25)
02(25)
100(25)
01(26)
03(26)
10(26)

I want to take the list and make it:

(25)01
(25)02
(25)100
(26)01
(26)03
(26)10

Can you help?

Thanks,
Bob

 

[Guest]

You can perform such conversion with a worksheet formula.

For example, if a cell A1 contains the text "100(24)". Then, in cell B1, you
type:
=RIGHT(A1,LEN(A1)-FIND("(",A1)+1) & LEFT(A1,FIND("(",A1)-1)

The formual will return the answer "(24)100"

Once you've placed the formula into the cell adjacent to A1, you can just
drag the formula downward to convert all the cells.

If you then want to convert all the formulas into static values, you can
COPY the cells, and the from Edit menu, choose "Paste Special", and choose to
paste "values".

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[Guest]

Thanks Edwin,

I'll give it a go.

Looks simple enough, just didn't know how to put it together.

Bob