Please do as follow. SUBSTITUTE G3 Press the Return key on your keyboard. Is there any way to change the default settings of Delimiters so that the Space delimiter does not automatically divide the data.
In this accelerated.
Step 1 Open the Excel spreadsheet you need to update. Right click on the workbook and insert a module. Function JoinText delimiter As String rng As Range Dim res As String For Each cell In rng If Trim cellValue Then res res Trim cellValue delimiter End If Next cell res Left res Len res - 1 JoinText res End Function Press CTRLF11 to open the VB Editor. Click on the Clock Language and Region link or search for it if not displayed.