Create tags for cells in excel mac 2011

broken image

We can use nested SUBSTITUTE to replace multiple texts. SUBSTITUTE is case-sensitive and does not support wildcards.

broken image

This replaces the specific text in any place in a text string. SUBSTITUTE function is a worksheet text function, this function substitutes or replaces the new text in the place of old text in a text string. SUBSTITUTE function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010. Excel version in which SUBSTITUTE function can work:

 

PreviousNext
Cookie Use
We use cookies to improve browsing experience, security, and data collection. By accepting, you agree to the use of cookies for advertising and analytics. You can change your cookie settings at any time. Learn More
Accept all
Settings
Decline All
Cookie Settings
Necessary Cookies
These cookies enable core functionality such as security, network management, and accessibility. These cookies can’t be switched off.
Analytics Cookies
These cookies help us better understand how visitors interact with our website and help us discover errors.
Preferences Cookies
These cookies allow the website to remember choices you've made to provide enhanced functionality and personalization.
Save