Removing+/- signs

[WasWodge]

I am sure there is an obvious answer to this but I haven't stumbled across it yet.
The problem is I have a spreadsheet that is a converted text file. Unfortunately the values in one of the columns end in either a + or - sign. Is there an easy way of removing the plus signs so I can do a sort on the column from highest to lowest or is there some way I can I format the column so it recognises +/- signs after the number?

[Richard Buttrey]

Hi,

Is there a space between the last digit and the sign. e.g. are they 123+ or 123 +

Rgds

[WasWodge]

No I'm afraid there is no spacing after the number and the original text file is left justified so the +/- signs don't line up which means I can't get around it by putting them in a separate column before conversion.

[Paul]

Hi Paul,

In another column, can you not use:

=SUBSTITUTE(A1,"+","")

This will remove any + sign in cell A1. You can fill that down as many rows as needed. If you need to convert the text to actual numbers, you could add

=SUBSTITUTE(A1,"+","")+0

To handle both + and -, you could try:

=IF(RIGHT(A1,1)="-",-(LEFT(A1,LEN(A1)-1)+0),LEFT(A1,LEN(A1)-1)+0)

[WasWodge]

Cheers Paul that solves the current problem and probaly a few later ones as well