format cell to remove numbers

[mikeydaman]

Hi guys,

I m looking to format a cell to remove numbers that i don't need.

For example, at work we can swipe a card and the card number comes up like so

;11=00=0370904?

is there a way to format the cell to remove everything but the 0370904

Thanks for any help
Mikey

[davesexcel]

Will there always be 7 digits?
=RIGHT(A1,7)

[Richard Buttrey]

Hi,

You could use a string slicing function in another cell. e.g. if the number is always 7 digits followed by a ? then

Please Login or Register  to view this content.

HTH

[mikeydaman]

Hi guys, thanks for your help and yes there will always be 7 digits. Both work great but i still get the ? mark in there and i can't have that as well.

Richard thanks for that but the LEFT should be RIGHT hehe

Thanks again for your help

[Richard Buttrey]

Hi,

Sorry, misread that as you wanting everything but the number. Try

Please Login or Register  to view this content.

If you want it as a number, wrap it in an =VALUE() function

Rgds

[mikeydaman]

That worked awesome! thanks again guys for your help

Cheers
Mikey