Forum Discussion

hassan_samy's avatar
hassan_samy
Copper Contributor
Sep 10, 2020
Solved

text to the column

I am using office 365 basic license I want anyway to change the text to the column with all function in the standard license
office 365
  • Ramiz_Assaf's avatar
    Ramiz_Assaf
    Sep 10, 2020

    hassan_samy 

     

    I fixed the previous file, 

    see the answer in row 13

    basically my formula searches for spaces then splits the columns based on the spaces found.

     

    hope it is clear

hassan_samy's avatar
hassan_samy
Copper Contributor
Sep 10, 2020
but what if I want to change this text to column
08TP 46678923.017 820007.016 250.916 0

note there many spaces between the number
Ramiz_Assaf's avatar
Ramiz_Assaf
Iron Contributor
Sep 10, 2020

hassan_samy 

 

I fixed the previous file, 

see the answer in row 13

basically my formula searches for spaces then splits the columns based on the spaces found.

 

hope it is clear

Resources