Try this for your above sample dataset:
UPPER(LEFT(SPLIT([Column A]," ",-1),1))+LOWER(RIGHT(SPLIT([Column A]," ",-1),LEN(SPLIT([Column A]," ",-1))-1))
I have taken data set as you Provided
Use the below formula to get the Output
Column A - Split 1:
UPPER(LEFT(LOWER(TRIM( SPLIT( [Column A], "Example", 2 ) )),1))+
MID((LOWER(TRIM( SPLIT( [Column A], "Example", 2 ) ))),2,LEN(
(LOWER(TRIM( SPLIT( [Column A], "Example", 2 ) ))))
Hope this helps Plz mark this answer as correct or helpful to close the thread.
Thank you for your suggestion, this is the ideal function for this kind of dataset, however I change my sample dataset, and I'm sure it won't work with what exactly I needed. Hope you guys will be able to help with the latest dataset. Thanks.
*Demo* East Jones
Pencil *Inactive* 95
Central DEMO Kivell Binder
DEMO Central Jardine Pencil
Central demo Gill
56 East Jones
Central Jardine Pencil
I want them to show as if any word "demo/inactive" is within the column A sentence tagged it as "Demo" else "Real":
COLUMN A COLUMN B
*Demo* East Jones Demo
Pencil *Inactive* 95 Demo
Central DEMO Kivell Binder Demo
DEMO Central Jardine Pencil Demo
Central demo Gill Demo
Pen West Real
Sorvino Pencil Real
56 East Jones Real
Andrews Pencil Real
Central Jardine Pencil Real
You can use this calculated field to get the output you want:
if contains(lower([Column A]), "demo") or contains(lower([Column A]), "inactive") then "Demo"
Let me know how that works out for you.
Paul it works! Thank you all. It's a big help!