Aug 17 2008

Substitute Formula

The substitute formula is an relatively simple formula that can come in handy in many situations.  I like to use this formula the most when a longer text field needs just a portion of it changed, without having to retype the entire cell value.  Let’s go ahead and take a look at the substitute formula:
=SUBSTITUTE(Text, [...]

XLAutomation
Get Expert Excel Help Today! 714.262.6893
Easily design MySQL databases as familiar spreadsheets in Micros
Easily design MySQL databases as familiar spreadsheets in Micros

Categories

Excel Poll of the Week

How often do you use Excel macros (VBA)?

View Results

Loading ... Loading ...