New Column in SharePoint List based on another column

Copper Contributor



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



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?





0 Replies