Substitute Function | Replace Text | How to use substitute function in excel

#excellearn #substitute #msexcel

Welcome All !

The function is about replacing old text with new or remove old text with nill value. We may use substitute function in many scenario like removing spaces from text or replace text with any desired text or as per requirement.

Please like, share, subscribe this channel

Please watch some other useful video of ms excel

1. Magic Tricks in Excel | AutoSum Function | Subtotal in Blank cell |

2. Sum, sumif, sumifs

Thanks All!!