Numbers and text together in column

[amey90210]

Dear all,

Could someone please help me to remove the texts, punctuation marks, i.e; hyphen's, slashes, colon etc from a particular column and get me only the numbers?

I'm an accountant by profession. If i could do this task in a jiff, i could have saved some time for other works as well.

Attached is the sample sheet for your kind reference.

Please help

The numbers that we see in Column C is very mandatory. These are the Receipt numbers and that's exactly what i need. I do not need these texts along with it....neither the punctuations..

Thanks
amey

[:) Sixthsense :)]

Refer the below link for details.

http://office.microsoft.com/en-us/ex...001154901.aspx

[MarvinP]

Hi amey and welcome to the forum

Put this formula in D4 and pull it down. I think that is what you want.

=LEFT(C4,FIND("/",C4)-1)