Re: HP and Functions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What else is in those cells?

Any chance that after the change, whatever is left looks like a formula and
doesn't make sense to excel?

Any chance that you're getting a "formula too long" message? This can happen
when there's lots and lots of text in the cell.

Mike S. wrote:

I'm trying to replace all instances of "HP2-" in a column of text with
"COC3-". Each time I run the Replace command, I get an error saying that the
formula is invalid.

I get the same error when I use "HP2" and "HP". When I try searching the
help files for "HP in Functions", I get a list of text functions and issues -
none of which show HP in the description.

What's happening? (I tried using MS Tech Support, but I'm not allowed to
pay the $50 fee and the free period is over. Grrrrr!)

--
Mike S.

--

Dave Peterson
.

Relevant Pages

  • Re: EXCEL 2003
    ... Microsoft MVP - Excel ... "Mike" wrote in message ... the code on Sheet2 in cells A1-A20, ...
    (microsoft.public.excel.newusers)
  • Re: #NAME? Problem
    ... Excel thinks the "+" sign makes the entry a formula. ... >Thanks Mike, but no, the words have already been typed. ... >them into the cells. ...
    (microsoft.public.excel.misc)
  • Re: Large Formula
    ... Microsoft MVP - Excel ... www.cpearson.com "Mike" wrote in message ... Any> suggestions how I can get the formula to work in non-adjacent cells would be> appricated. ...
    (microsoft.public.excel)
  • Re: Excel 2007 data list
    ... Sorry Mike ... Select your range of cells in column A>Home tab>Conditional Formatting>New rule>Use a formula to Determine which cells to format>enter the formula in the white pane that appears>click Format>Fill>Colour ... "Mike Johnson" wrote in message ... I want to make Excel get the next weekday automatically. ...
    (microsoft.public.excel)
  • find combination of cells that equals a sum
    ... "Would there by chance be a function in Excel where you can choose a range ... of cells with an amount in each cell and see if any combination of those ...
    (microsoft.public.excel.programming)