Formatting Question

[ctrapper]

in my spread sheet, I am copying and pasting table rows from and internet table. One cell contains the value UP(+100) I need the UP to be in one cell and the (+100) to be in it's own cell. I can use the Text to Columns and separate by using the ( but parenthesis are being used in other parts of the row, so when I come in the next day to add a new row, it formats it wrong. Is there a way to pop a formula in Column G, to tell excel just populate what is in front of the (.

[ragulduy]

If A1 is:
UP(+100)
then in G1:
=RIGHT(LEN(A1)-SEARCH("(",A1,1)+1)
shoudl return:
(+100)

[ctrapper]

Hi Ragulduy.. the UP(+100) is actually in F2, so I am putting your formula in G2, but it's returning a # value of 6? Even when I put it in A1, it still returns a # value? Also, if possible, I'd like to display the UP not the (+100).

[Sam Capricci]

I suppose that a simple =LEFT(F2,2) won't work for this?

[ragulduy]

Sorry, too late on a Friday, I should have checked it first:
=RIGHT(F1,LEN(F1)-SEARCH("(",F1,1)+1)
in G1 if your UP(+100) is in F1.

[ctrapper]

Actually they both worked guys! Much appreciated! Have a good weekend!