Microsoft Excel: How to remove space in between the text
Description
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.
Syntax
SUBSTITUTE(text, old_text, new_text, [instance_num])
The SUBSTITUTE function syntax has the following arguments:
Text Required. The text or the reference to a cell containing text for which you want to substitute characters.
Old_text Required. The text you want to replace.
New_text Required. The text you want to replace old_text with.
Instance_num Optional. Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.
#MicrosoftExcel #MicrosoftAccess #SUBSTITUTE
#MsExcel
#MsAccess
#MsExcelTutorial
#MsAccessTutorial
#MicrosoftAccess
#MicrosoftExcel
Bliss by Luke Bergs | / bergscloud
Creative Commons - Attribution-ShareAlike 3.0 Unported
https://creativecommons.org/licenses/...
Music promoted by https://www.chosic.com/free-music/all/
KEYWORDS:
#fasttips, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database
#KamayoAko,#MsExcel, #MsAccess,#msaccesstipsandtricks,#microsoftaccess,
#msaccess,#microsoftaccessdatabase,#microsoftoffice,#stratvert,#stratvert,#Access,#Beginner,#Tutorial,#Microsoft,Access Beginner Tutorial,Microsoft Access Tutorial,microsoft access, ms access, #msaccess, #microsoftaccess, order entry, order form, order details, billing, receipt, invoice, invoicing, invoice report, order template, invoice template, purchase order, accounting, order management, order entry form, invoicing template, invoice template, quotation,#StockIn,#StockOut, Stock In, Stock Out,#BOM,Bill of material,#Accounting,#Ledger,#Credit,#Debit,#OpeningBalance,#ClosingBalance,#BookKeeping,Book Keeping,#moresubscribers2022 #moreviews2022 #GrowYourChannel,#moresubscribers2023 #moreviews2023, more subscribers 2022, more views 2023,more subscribers 2023, more views 2023,
#VBA Masters
#Sissoko M. Prodev
/ @sissokom.prodev9979
#Alessandro Grimaldi
/ papillon0365
✅ Recommended playlists:
Worksheet Basics
• Worksheet Basics
Microsoft Excel Essentials
• Microsoft Excel Essentials
Ms Access Fundamentals Series
• Ms Access Fundamentals Series
Microsoft Access Essentials
• Microsoft Access Essentials