Solved Excel Copying Part of a Cell to a new cell

August 31, 2014 at 13:06:22
Specs: Windows 7
BAKERY PRODUCTS:DR.OETKER:4000521002466

I have this on the cell, and I need to copy the digits to the left column. I have tried the advice given here, somehow it did not work

Pls help
Kira


See More: Excel Copying Part of a Cell to a new cell

Report •

#1
August 31, 2014 at 18:36:28
✔ Best Answer
Try this,

With your data in cell A1, put this formula in A2 and you should get just your numbers:

=TRIM(RIGHT(SUBSTITUTE(A1, ":", REPT(" ", 100)), 100))

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question