Re: Stripping nubers from text in a cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Needs to trim the space in the first example.

--
Biff
Microsoft Excel MVP


"Ron Coderre" <ronREMOVETHIScoderre@xxxxxxxxxxx> wrote in message
news:%230RVA$9fIHA.4880@xxxxxxxxxxxxxxxxxxxxxxx
Certainly better than what I threw together.
(I don't know WHAT I was thinking.)

Ron



"Rick Rothstein (MVP - VB)" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote in
message news:OD$8739fIHA.2000@xxxxxxxxxxxxxxxxxxxxxxx
Assuming your text is not longer than 999 characters and that your digits
are all next to each other (no leading or intervening spaces or
characters)...

=MID(A1,SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1)))+1,999)

Rick


"Dan S" <DanS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9A146212-B177-4E36-A36B-A5F32A13326A@xxxxxxxxxxxxxxxx
I have a bunch of cell with varying lench that have numbers at the
beginning
(also of varying length. Ex:

1258 ahjKJ yuUIOI
45687045HJKoiuwER

I just want to extract the text from these cell. How do I do that?

Thanks,
Dan





.

Relevant Pages

  • Re: Lookup question and iferror compatibility
    ... I would extract the letters to another cell then do the "lookup" on that other cell. ... Microsoft Excel MVP ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to separate text and numbers in one cell or column?
    ... Let's assume you have this formula to extract the numbers in cell B1: ... Microsoft Excel MVP ... I generally have to post process this file in UNIX before I import it ...
    (microsoft.public.excel.worksheet.functions)
  • Re: extract number in sequence
    ... Microsoft Excel MVP ... Select cell A1 ... Goto the menu Data>Text to Columns ... extract them from cell a1 and put it in ...
    (microsoft.public.excel)
  • Re: extract number in sequence
    ... Microsoft Excel MVP ... Select cell A1 ... Goto the menu Data>Text to Columns ... extract them from cell a1 and put it in ...
    (microsoft.public.excel)
  • Re: Copy formatting, Help
    ... appears until I enter a number in a cell then the high number goes to the red ... Valko" wrote: ... Goto Format>Conditional Formatting ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)