Brewster Gillett enquired: > > I've pawed through every HELP screen in Calc and can't find a way > > to do this. <snip>
Harold Fuchs replied: > You need to use Regular Expressions in the Find & Replace dialog. <snip> bg: Man, does that ever work - thank you very much. I never knew REs were available in spreadsheets - and I sure didn't find any mention of them in the help screens.Probably should have looked in the online version. hf: > You might want to backup your spreadsheet before you do this, just in case > ;-) bg: I always write out a "temp work copy" - same effect. I usually manage to avoid experimenting on original files :-) hf: > Read up about Regular Expressions in the Help or other online documentation > to learn what is happening. They are extremely useful. bg: I'll do that - there's some real power there to be had. I'll bet that if I can learn enough about how to use them, I can solve some other "global update" issues I have dangling around. Thanks again, and I'll stand you a pint at your local if I get over that way any time soon. Brewster -- ****************************************************************** W. Brewster Gillett [EMAIL PROTECTED] Portland, OR USA ****************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
