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

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.

Thanks for your help