If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
replacing with a tick
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". |
#2
|
|||
|
|||
replacing with a tick
If you start with column A with something like this in it:
TRUE FALSE FALSE TRUE FALSE Then do this: 1 replace "TRUE" with ü (you can copy that character out of here) 2 replace "FALSE" with û (ditto) 3 select column A and change the font to Wingdings -- Allllen "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". |
#3
|
|||
|
|||
replacing with a tick
Thanks that's great.
"Allllen" wrote: If you start with column A with something like this in it: TRUE FALSE FALSE TRUE FALSE Then do this: 1 replace "TRUE" with ü (you can copy that character out of here) 2 replace "FALSE" with û (ditto) 3 select column A and change the font to Wingdings -- Allllen "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". |
#4
|
|||
|
|||
replacing with a tick
Can you give me a tick then for answering correctly?
it would be nice -- Allllen "Boots" wrote: Thanks that's great. "Allllen" wrote: If you start with column A with something like this in it: TRUE FALSE FALSE TRUE FALSE Then do this: 1 replace "TRUE" with ü (you can copy that character out of here) 2 replace "FALSE" with û (ditto) 3 select column A and change the font to Wingdings -- Allllen "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". |
#5
|
|||
|
|||
replacing with a tick
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 |
#6
|
|||
|
|||
replacing with a tick
Thanks James that is nice to know.
How is the weather in Maryland? -- Allllen "James Silverton" wrote: 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 |
#7
|
|||
|
|||
replacing with a tick
Hello, Allllen!
You wrote on Mon, 11 Sep 2006 07:21:03 -0700: A Thanks James that is nice to know. A How is the weather in Maryland? A -- A Allllen I don't know if you really wanted to know :-) But just in case, I've gone from having to use the A/C after midnight three weeks ago to switching on the house heating last week! James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
#8
|
|||
|
|||
replacing with a tick
Sure I did. Crazy weather we are all having. I have also just switched my
central heating on here in Belgium -- Allllen "James Silverton" wrote: Hello, Allllen! You wrote on Mon, 11 Sep 2006 07:21:03 -0700: A Thanks James that is nice to know. A How is the weather in Maryland? A -- A Allllen I don't know if you really wanted to know :-) But just in case, I've gone from having to use the A/C after midnight three weeks ago to switching on the house heating last week! James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Thread Tools | |
Display Modes | |
|
|