Hello, Allllen!
You wrote on Mon, 11 Sep 2006 06:26:02 -0700:

A TRUE
A FALSE
A FALSE
A TRUE
A FALSE

A Then do this:
A 1 replace "TRUE" with ü (you can copy that character out of
A here) 2 replace "FALSE" with û (ditto)
A 3 select column A and change the font to Wingdings
A --
A Allllen

A "Boots" wrote:

?? Hi, I have exported data fom access, in which some of the
?? field contain checkboxes. These appear as true and false
?? in excel. Rather than manually changing them indivdually
?? to ticks and crosses, from the symbol menu, how can I use
?? the find and replace function to do this. I can't get the
?? find and replace function to recognise a "tick" as it just
?? comes out as "P".


May I also express my admiration for a very ingenious solution
even if I have no need or prospect for using it!
I'd like to add that I have found that having the character map
available as part of my Office Shortcut bar is very useful for
this sort of thing.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not