# Remove Plus Signs From Numbers

• I have a list of numbers in Column A that I always copy into another sheet. The problem I have is that some of these numbers end in "+" and I can't use them when it has that. I have to go through and one by one take out the plus. I was wondering if it was possible to copy only the numerical values to a new column?

Example

Original What Im Looking For

4 4
56 56
8+ 8
5 5
90 90
2 2
4+ 4
45 45
1 1
67 67

Thanks[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Actually I just figured it out. I did a text to columns with a + sign as the separator and it worked.

Thanks to all who looked at it.

• Re: Copy All Numerical Values From Column

Perhaps try to remove first the +:
Assuming data in A3
in B3 =SUBSTITUTE(A3,"+","")

Triumph without peril brings no glory: Just try

• Re: Copy All Numerical Values From Column

I was actually able to add a text to columns into my macro that separated the columns by a plus sign. This removed the plus sign and I havn't seen any problems yet.

I'll try yours too just to see if it calculates it quicker as there are A LOT of rows for this to run through.

• Re: Copy All Numerical Values From Column

Give a chance to next formulaes:
Assuming data in column A
In column B: =SUBSTITUTE(A1,"+","")
In column C: =LEFT(B1,FIND(" ",B1))*1
In column D: =RIGHT(B1,LEN(B1)-FIND(" ",B1))*1
Then Copy and special paste column C & D in themselves.
Column B could be integrated in column C & D

Triumph without peril brings no glory: Just try

• Re: Copy All Numerical Values From Column

Edit>Replace Replace What=+ and leave the Replace with blank. You made to run again to remove spaces.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!