Can't apply "Text To Columns" delimited by space

  • Re: Can't apply "Text To Columns" delimited by space


    That is because you are not using spaces (ASCII 32) You are using (ASCII 160) characters.

  • Re: Can't apply "Text To Columns" delimited by space


    Quote from jonny;651720

    This is an automatically exported report. Is any way to fix this by macro?


    Code
    Public Sub Convert_Space()
    
    
    ActiveSheet.UsedRange.Replace Chr(160), Chr(32)
    
    
    End Sub

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!