Thinsk
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 37 articles for 0.303 sec
? is a wild card representing a single character. * is a wild card representing any number of characters. You use ~ as the "escape" character which tells excel to look for a real ? or asterisk. ~? to find ? ~* to find * ~~ to find ~ (I had too many ~~ in that last one!) Dave Peterson wrote: > > ? is a wild card representing a single character. > * is a wild card representing any     

Group: microsoft.public.excel.misc · Group Profile · Search for Thinsk in microsoft.public.excel.misc
Author: Dave Peterson
Date: Apr 8, 2008 13:24

? is a wild card representing a single character. * is a wild card representing any number of characters. You use ~ as the "escape" character which tells excel to look for a real ? or asterisk. ~? to find ? ~* to find * ~~ to find ~~ smartgal wrote: Brilliant!! Worked like a charm. Any other goofy little characters like this I might want to keep on my radar? "Gary''s
Show full article (1.39Kb) · Show article thread
Brilliant!! Worked like a charm. Any other goofy little characters like this I might want to keep on my radar? "Gary''s Student" wrote: > try: > ~* > -- > Gary''s Student - gsnu200777 > > > "smartgal" wrote: > > > I am stripping extraneous characters out of some data but having trouble > > finding the * character. If I do a find and replace for * to replace with > > (delete     

Group: microsoft.public.excel.misc · Group Profile · Search for Thinsk in microsoft.public.excel.misc
Author: Dave Peterson
Date: Apr 8, 2008 11:38

The asterisk * is used as a wildcard (i.e. any number of characters) in the operations you have tried. To have Excel treat it as a character, you must preceed it with a tilde symbol ~, eg in Find/ Replace: Find What: ~* Replace with: leave blank will just remove the asterisk characters. Hope this helps. Pete On Apr 8, 7:15 pm, smartgal <smart...@discussions.microsoft
Show full article (1.00Kb) · Show article thread
try: ~* -- Gary''s Student - gsnu200777 "smartgal" wrote: > I am stripping extraneous characters out of some data but having trouble > finding the * character. If I do a find and replace for * to replace with > (delete) it wipes out all the data in that column. Also, I can't filter for > "contains *" because it thinsk all the entries have it. Is * a special > character? Is there     

Group: microsoft.public.excel.misc · Group Profile · Search for Thinsk in microsoft.public.excel.misc
Author: smartgal
Date: Apr 8, 2008 11:32

I am stripping extraneous characters out of some data but having trouble finding the * character. If I do a find and replace for * to replace with (delete) it wipes out all the data in that column. Also, I can't filter for "contains *" because it thinsk all the entries have it. Is * a special character? Is there anything I can do so the program will recognize it as a text character rather
Show full article (0.69Kb) · Show article thread
krzgirl wrote: > On Jan 8, 6:50 am, "Stephanie" <h...@noway.net> wrote: >> krzgirlwrote: >>> On Jan 7, 4:13 pm, Nina <ninaNOS...@economika.net> wrote: >> >>>>> Well, she and the marriage counselor are the ones trying to trash >>>>> me, remove me and got him to lie and say he didn't love me. Why >>>>> don't they allow him to tell the truth and maybe, just maybe he >>>>> would and I would be     

Group: microsoft.public.excel.misc · Group Profile · Search for Thinsk in microsoft.public.excel.misc
Author: Pete_UK
Date: Apr 8, 2008 11:25

weteyes (mbulseco@hotmail.com) writes: On Nov 25, 5:34 am, bc...@FreeNet.Carleton.CA (Eleonore Beaudoin) wrote: Last night, at 23:28, Titan died.......... In memory of the lil life that made mine filled wtih giggles and awe these= last 5 years, 2 months and 24 days, a repost of some moments, starting from the day I found her, poisoned, and brought her back to life
Show full article (0.86Kb) · Show article thread
On Nov 25, 5:34 am, bc...@FreeNet.Carleton.CA (Eleonore Beaudoin) wrote: > Last night, at 23:28, Titan died.......... > > In memory of the lil life that made mine filled wtih giggles and awe these > last 5 years, 2 months and 24 days, a repost of some moments, starting > from the day I found her, poisoned, and brought her back to life > after turning her upside down. I then had gone online     

Group: microsoft.public.excel.misc · Group Profile · Search for Thinsk in microsoft.public.excel.misc
Author: Gary''s Student
Date: Apr 8, 2008 11:22

Hi Chloe, Another sad loss for you with the passing of Titan. I enjoy reading your messages concerning your pets that are full of love and compassion. They will surely be missed, but not forgotten. Years of tender loving care and joy. Our thoughts are with you, Carl "Eleonore Beaudoin" <bc461@FreeNet.Carleton.CA> wrote in message news
Show full article (0.52Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for Thinsk in microsoft.public.excel.misc
Author: smartgal
Date: Apr 8, 2008 11:15

Show full article (0.44Kb)
    

Group: alt.support.marriage · Group Profile · Search for Thinsk in alt.support.marriage
Author: Stephanie
Date: Jan 8, 2008 07:04

Show full article (1.68Kb) · Show article thread
    

Group: alt.support.loneliness · Group Profile · Search for Thinsk in alt.support.loneliness
Author: Eleonore Beaudoin
Date: Nov 26, 2007 04:13

Show full article (11.26Kb) · Show article thread
    

Group: alt.support.loneliness · Group Profile · Search for Thinsk in alt.support.loneliness
Author: weteyes
Date: Nov 25, 2007 22:33

Show full article (10.40Kb) · Show article thread
    

Group: alt.support.loneliness · Group Profile · Search for Thinsk in alt.support.loneliness
Author: Carl P
Date: Nov 25, 2007 08:49

Show full article (23.95Kb) · Show article thread
1 · 2 · 3 · 4 · next