text to the column

[hassan_samy]

I am using office 365 basic license I want anyway to change the text to the column with all function in the standard license

[#2]

@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

[#3]

thanks @Ramiz_Assaf 

[#4]

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

[#5 · Accepted solution]

@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

[#6]

thanks @Ramiz_Assaf