Search results

Cell contents are Test|000123, Test1|067, and Test2|ABC. I want to maintain 000123 and 067 as text values after splitting the cells using the "|" as a delimiter. I cannot figure out how to maintain the leading zeroes (it varies from cell to cell) using Text to Columns. Any ideas?

I'm using MS Office Professional Plus. I'd like to invoke the Apply Rule to . . . option when CF a PT. But no matter how I try, I never get the option to CF based on - Selected Cells - All Cells showing "XXX" values - All Cells showing "XXX" values for "YY"

No, it's not protected. If I do protect the worksheet/workbook, the cursor changes to a thick down arrow. Weird!

Let me check. Even though I don't get the two sided arrow, I can double click the border and get the auto-sizing effect.

It's only happening on selected workbooks. Is there an option that perhaps is toggled off/on? The symptom is straightforward: as I move the cursor horizontally across the column/row headings the cursor arrow doesn't change to the double-sided arrow as it crosses the border. Any ideas?

Nevermind . . . I was lazy and should have done a little research beforehand. Here's the solution, in case anyone's interested. Select the range you'd like to search. 1. Press Ctl-F to invoke the Find/Replace dialog box and then select the Find tab. 2. With nothing in the Find What box...

Using Go To ... Special, you can find and isolate cells with either blanks or non-blanks, then using Ctl-Enter you can replace the contents globally. Is there a way to find and isolate cells (with/without a macro) filled with a particular color? border? etc.? Thank you in advance

No formulae, no spaces. Open a new worksheet, CTRL F, press Find Next or Find All. I get a message box saying "Microsoft Excel cannot fin the data you're looking for." It should, in theory, select the entire worksheet since all cells contain nothing, right?

Luke, that doesn't work for me. I can put values in A1, A2, and A4, select that range, attempt to find nothing, and it returns nothing. I want it to come back with A3.