SOLVED

Splitting text from a cell

Copper Contributor

Hi All,
I would like to separate the data in this cell - having the numeric value (with the letter class) in one column and the text (description) in another column. If I do a =LEFT(A2,9) I can extract the number and letter class, I am just a little stuck in getting the rest of the text into another column. Could I ask for a little help please.
Support page
Here is an example - 111120a - (PRP) Oilseed (except Soybean) Farming

4 Replies
best response confirmed by NBBingo1858 (Copper Contributor)
Solution

@NBBingo1858 If you always want the 2nd column to contain everything except the first 9 characters use this:

=RIGHT(A2),LEN(A2)-9)

@Riny_van_Eekelen 

Thanks for this. But I keep getting this error message

NBBingo1858_0-1675954597193.png

 

missing bracket. =RIGHT(A2),LEN(A2)-9) should be =RIGHT((A2),LEN(A2)-9) now it works. Many thanks for the formula though.

@NBBingo1858 Oooops. Actually, one bracket too many.

=RIGHT(A2,LEN(A2)-9)

 

:)

1 best response

Accepted Solutions
best response confirmed by NBBingo1858 (Copper Contributor)
Solution

@NBBingo1858 If you always want the 2nd column to contain everything except the first 9 characters use this:

=RIGHT(A2),LEN(A2)-9)

View solution in original post