Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Split text in calculated column

Hi All, Need some urgent help , I need to split text in calculated column as below please note it is a claculated column so please do not suggest any power quesry tricks it wont work it has to do wit...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Check this 

    Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amit it is throwing error search has the wrong data type or invalid value

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Check this 

Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))