Can someone tell me how I would go about ignoring punctuation when
sorting in Excel 2003?

Thanks in advance for your help.

Dave

On Thu, 27 Sep 2007 21:23:14 -0400, Dave wrote:

Can someone tell me how I would go about ignoring punctuation when
sorting in Excel 2003?

Thanks in advance for your help.

Dave

Use a helper column from which you have removed the punctuation. You possibly
need to use nested substitute functions, unless you have more than seven types
of punctuation marks to remove.
--ron