Re: Searching for text

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

Does this do what you want (adjust the ranges accordingly)...

=INDEX(A1:A100,MATCH("*",A1:A100,0))

--
Rick (MVP - Excel)


"EBnLP01" <EBnLP01@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:DF47F7FC-8634-44A3-AFA6-5717277F69F6@xxxxxxxxxxxxxxxx
a1=BR549
a2="" (empty space)
a3="" (empty space)
a4=BR549

what i'm looking for, is a formula that will search these cells for a TEXT
value and then display that text. but where i'm having problems, is
depending on what else happens, the text "BR549" can be "M8FR2" or "G8E34".
but no matter what, the text within the column will always be the same. i
haven't mastered using wild cards, i always get an error when i try to use
them.

Any help is welcomed !!!

Thanks in advance
EBnLP01


.

Relevant Pages

  • Re: Removing Blank Cells
    ... Excel is actually using. ... way out into empty space then you would be wasting ... If you need to make another cell your last cell to drop ... If you have 3 sheets and use only 2 sheets you could drop that ...
    (microsoft.public.excel.misc)
  • Re: headers-excel file-bad data
    ... Looks like I have an empty space somewhere...this code is called down in a ... I have an excel file that I am generating. ... download it using the headers below, when I then open it excel complains ... that it is an unrecognizable format and the info is garbled...any ideas??? ...
    (php.general)
  • Re: Why cant I see my cell selections?
    ... Try changing the Windows Appearance (right click empty space on desktop and ... Microsoft Excel MVP ... Is there a way to adjust the color for selecting cells? ...
    (microsoft.public.excel.misc)
  • Re: sum last rows
    ... Microsoft MVP Excel ... Rick ... Change my 'Data Sheet' to the name of your sheet with the columns you are adding ...
    (microsoft.public.excel.programming)
  • Re: Saving a file to desktop with VBA
    ... Rick (MVP - Excel) ... Windows, although I don't know that for sure as I do not do any ...
    (microsoft.public.excel.programming)