Copying only the numbers from a cell
Posted on 2013-10-22
I have a large column that has a combination of letters and numbers. They are not consistent , some has letters, and some has charterers like blank, (, or &.
Is there a way for me to copy to another column with just the numbers and have them stacked next to each other,
So for example, if the cell contains (#125-54A24) it will copy 1255424
So for example, if the cell contains -AA 23- 56267 it will copy 2356267