Hi

I have an existing SharePoint list with 600+ rows where I’m trying to add an additional column based of an existing column.

Existing Column is Product and is a text field that contains the product description in the format: colour range type

e.g.

Blue RangeName TypeName
Dark Blue RangeName TypeName
Light Blue RangeName TypeName

I want my new column to extract the Colour from the product text.( Where colour may be more than 1 word)

I’m struggling to work out how I can do this. I essentially need to remove the last 2 words from the product text to obtain the colour.

Does anyone have any suggestions?

Thanks

​Hi I have an existing SharePoint list with 600+ rows where I’m trying to add an additional column based of an existing column.Existing Column is Product and is a text field that contains the product description in the format: colour range type e.g.Blue RangeName TypeNameDark Blue RangeName TypeNameLight Blue RangeName TypeName I want my new column to extract the Colour from the product text.( Where colour may be more than 1 word) I’m struggling to work out how I can do this. I essentially need to remove the last 2 words from the product text to obtain the colour. Does anyone have any suggestions? Thanks    Read More

​