Hash Character

[Grandad]

Hi All

Is there a way to find the # character by using "Find" when it is displayed
because the column width is not wide enough to display all the characters in
a cell?

 

[Don Cameron]

Mick
The # character you see when the column is not wide enough is not actually a
character in the cell. It is a display format to show "col not wide enough
to display the result". The cell contains the value so searching for the #
will not find it.
If you suspect that a column may not be wide enough to show all then
double-click the column divider on the right side of the column - Excel will
adjust the width to show all of the longest content of any cell in the
column.

Cheers
Don

 

[Grandad]

Thanks Don

I do understand why it appears, it's just that I was after a quick way to
find the # on a very large sheet prior to printing.

Thanks anyway

Mick

 

[Gord Dibben]

Grandad

Edit>Find

what: ALT + 0035

Find All.

Gord Dibben Excel MVP

 

[NH]

Go to edit>find
type # in the search box
click on options
select Look in values
Find all

 

[Gord Dibben]

NH

That's too easy<g>

Thanks, Gord

Go to edit>find
type # in the search box
click on options
select Look in values
Find all

 

[Myrna Larson]

I could be even easier. You can type a # symbol in the box directly. Too bad
it doesn't work <g>. As Don Cameron said, the cell probably doesn't contain
and # characters. If you widen the column, you can see that.

 

[Gord Dibben]

Myrna

In a column of dates I drag the column width so the ####'s appear.

I edit>find> # and check Values.

Excel 2002 returns all cells in that column.

Gord

 

[Myrna Larson]

Ah.... I missed the part about having to search in values (rather than the
default, formulas). Thanks for the clarification.

Myrna

In a column of dates I drag the column width so the ####'s appear.

I edit>find> # and check Values.

Excel 2002 returns all cells in that column.

Gord

I could be even easier. You can type a # symbol in the box directly. Too bad
it doesn't work <g>. As Don Cameron said, the cell probably doesn't contain
and # characters. If you widen the column, you can see that.

NH

That's too easy<g>

Thanks, Gord


Go to edit>find
type # in the search box
click on options
select Look in values
Find all


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Grandad

Edit>Find

what: ALT + 0035

Find All.

Gord Dibben Excel MVP

 

[Grandad]

Gord and everyone else that contributed..

Just what I needed, thanks to one and all.

Regards
Mick

Ah.... I missed the part about having to search in values (rather than the
default, formulas). Thanks for the clarification.

Myrna

In a column of dates I drag the column width so the ####'s appear.

I edit>find> # and check Values.

Excel 2002 returns all cells in that column.

Gord

I could be even easier. You can type a # symbol in the box directly. Too bad
it doesn't work <g>. As Don Cameron said, the cell probably doesn't contain
and # characters. If you widen the column, you can see that.

 

[Gord Dibben]

Happiness is our goal. Thanks for the feedback.

Gord

Gord and everyone else that contributed..

Just what I needed, thanks to one and all.

Regards
Mick

Ah.... I missed the part about having to search in values (rather than the
default, formulas). Thanks for the clarification.

Myrna

In a column of dates I drag the column width so the ####'s appear.

I edit>find> # and check Values.

Excel 2002 returns all cells in that column.

Gord

On Wed, 15 Sep 2004 20:37:03 -0500, Myrna Larson

I could be even easier. You can type a # symbol in the box directly. Too bad
it doesn't work <g>. As Don Cameron said, the cell probably doesn't contain
and # characters. If you widen the column, you can see that.