Gtag

Admin

How to add space between characters in excel

Do you want to add space between character in excel? Are you confused?

Don't worry we are here to help you

Just open your excel file and press "Alt+F11
Below window will be open 


Type paste the below code in Module (If module is not available just create by inserting option)

Function AddSpace(Str As String) As String
    Dim i As Long
    For i = 1 To Len(Str)
        AddSpace = AddSpace & Mid(Str, i, 1) & " "
    Next i
    AddSpace = Trim(AddSpace)
End Function

and save file after that use =AddSpace(A1) formula to add space