Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » Multiple Substitute Formula

Multiple Substitute Formula

MaryAnn asks an interesting question. In column A there is text that may or may not contain the name of a US state. In column B there is a list of US states. In column C, we want the column A text without the state names. I think this would be a pretty [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2009/12/09/multiple-substitute-formula/

Posted Dec 09 2009, 09:30 AM by Daily Dose of Excel
Filed under: ,
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.