Forum Discussion

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

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

5 Replies

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
- 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
    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
- hassan_samy
  Copper Contributor
  Sep 10, 2020
  thanks Ramiz_Assaf