format cell to remove numbers

**mikeydaman** · 11-26-2009, 07:50 PM

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** · 11-26-2009, 08:04 PM

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

**Richard Buttrey** · 11-26-2009, 08:04 PM

Hi,

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

Code:

=LEFT(A1,LEN(A1)-8)

HTH

**mikeydaman** · 11-26-2009, 08:15 PM

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** · 11-26-2009, 08:24 PM

Hi,

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

Code:

=MID(A1,LEN(A1)-7,7)

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

Rgds

**mikeydaman** · 11-26-2009, 08:27 PM

That worked awesome! thanks again guys for your help

Cheers
Mikey

Thread: format cell to remove numbers

Thread Tools

Display

format cell to remove numbers

Re: format cell to remove numbers

Re: format cell to remove numbers

Re: format cell to remove numbers

Re: format cell to remove numbers

Re: format cell to remove numbers

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions