View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Remove Numbers from Alphanumeric String

You can start he

http://www.cpearson.com/excel/ArrayFormulas.aspx

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave" wrote in message
...
This formula does work when enterred as you mentioned. Can you please
provide
some info on what this CSE method is and why it is used. It is new to me.

Thanks!
Dave

"Ragdyer" wrote:

Probably because you *didn't* enter it the proper way.
It's an *array* formula!
--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.

You can click in the cell containing the formula.
Then click in the formula bar, hold down
<Ctrl and <Shift
Then hit <Enter
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave" wrote in message
...
This returns #N/A

"Bob Umlas" wrote:

if it's always the 4th position, then =mid(A1,4,255). If you want it
to

be
numeric, then =1*mid(a1,4,255).
If the position is unknown but is always letters followed by numbers,
ctrl+shift+enter this:

=1*MID(A1,MATCH(FALSE,ISERROR(1*MID(A1,ROW($1:$20) ,1)),0),255)

Bob Umlas
Excel MVP

"Dave" wrote in message
...
Hi,

I have a value in Cell A of ABC123.

I want Cell B1 to contain the 123 from this cell.

Can anyone tell me the formula to enter in B1. I'm sure I've seen
it
somewhere before but can't put my finger on it.

Thanks!
Dave