I'm assuming that you are meaning the function of filtering (auto, standard and advanced filtering) within Calc.
You can use regular expressions (which will allow you to do what you want) by selecting the 'more' option after choosing advanced filtering. More assistance on regular expressions that may assist can be found in the inbuilt help files. Check them out. /paul On 9/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hai, > > How to use "Contains, Starts with," etc., filter comments in > Spreadsheet/Calc? > > Regards > N. Sivasakthi > Helpdesk Engineer > LMW-Unit I-FM Team > Extn : 5512480 / 2481 > "This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. If you have received this email in error please notify the system > manager. Please note that any views or opinions presented in this mail are > solely those of the author and do not necessarily represent those of the > company. Finally, the recipient should check this email and any attachments > for the presence of viruses. The company accepts no liability for any damage > caused by any virus transmitted by this email."
