Forum Discussion
Extracting the Words from the Cell
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.
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.
Riny_van_Eekelen Thank you for your prompt reply. Here are the conditions that I have summarized based on the data that I have. There are 8 conditions in total. Some of the contents have "-" after the quotation number but some of them don't have. However, it can be treated as 1 string.
May I know do you have any method to extract the words only from the cells?
