Forum Discussion
Extracting the Words from the Cell
Hi all,
Here's my question:
There are some contents in cell B4 to B6. I would like to know is there any formula to extract the words and put them into cell C4 to C6?
renjie0315 Then perhaps this:
=RIGHT(B4,LEN(B4)-FIND(" ",B4)-1)
In stead of stripping off the first nine characters it finds the space between the code and the text.
If this is still not giving consistent results, please provide an example that includes all possible inconsistencies. There are other, more stable ways to do this kind of job.
7 Replies
renjie0315 If the strings are as consistent as the screenshot suggests you can use
=RIGHT(B4,LEN(B4)-9)
That strips the first 9 characters leaving whatever come after.
Riny_van_Eekelen Unfortunately it's not consistent, some of the strings have -R1 for revision control. May I know do you have any method to counter this problem? Can I use IF statement to achieve it?
renjie0315 Then perhaps this:
=RIGHT(B4,LEN(B4)-FIND(" ",B4)-1)
In stead of stripping off the first nine characters it finds the space between the code and the text.
If this is still not giving consistent results, please provide an example that includes all possible inconsistencies. There are other, more stable ways to do this kind of job.
