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

Ramiz_Assaf's avatar
Ramiz_Assaf
Iron Contributor
Sep 10, 2020

hassan_samy 

 

if you want to transform a text let's say it is "aaaaaa" to 6 columns

 

https://tinyurl.com/simpleexcel

 


you can use the "MID" function, it will take a number of characters starting from a certain character

see the file

 

hope it is useful

Resources