Jan 03 2022 06:53 AM
Hello, I need to separate a text into columns.
For example, the text looks like this: IT00584002150
I need to get IT in one column and the number 00584002150 in the next column.
Unfortunately, when I use Text in columns, the first zeroes are omitted and the result is 584002150.
I have tried putting the format in text but nothing has changed.
Thank you
Carlotta
Jan 03 2022 07:03 AM
@charly365 In Step 3 of 3 you can data type the second column as Text. That should fix it.
Jan 03 2022 07:28 AM
Jan 03 2022 07:49 AM
@charly365 Then you must be something wrong. Another option is to use the the MID function for each of the parts of the string you want to separate.