Forum Discussion
Solved
Splitting text from a cell
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 extr...
NBBingo1858 If you always want the 2nd column to contain everything except the first 9 characters use this:
=RIGHT(A2),LEN(A2)-9)
NBBingo1858 If you always want the 2nd column to contain everything except the first 9 characters use this:
=RIGHT(A2),LEN(A2)-9)
- missing bracket. =RIGHT(A2),LEN(A2)-9) should be =RIGHT((A2),LEN(A2)-9) now it works. Many thanks for the formula though.
