New Column in SharePoint List based on another column

Copper Contributor

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

 

 

0 Replies