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.