adamp_nz
Jun 20, 2024Copper Contributor
New Column in SharePoint List based on another column
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