how to Add space as separator in the values of column.

[Bansi08]

I have values as SeniorLevel, JuniorLevel and MidLevel in column ABC. how can i add space in the values and separate the word as Senior Level, Junior Level and Mid Level. 

Can anyone please help me.  

[FrederikE · Accepted solution]

Hey @Bansi08,

If the seperation always has to happen before 'Level', you can use a simple REPLACE and replace it with the same + a space. 

REPLACE([Field],"Level"," Level"). 

If the logic gets more complicated then just placing it before level, you would prob. need to use Regex and define smth. like a uppercase character to replace with " "+ the letter. 

[binuacs · Accepted solution]

@Bansi08 One way of doing this as mentioned by @FrederikE 

[Bansi08]

Thanks Frederik. RegEx function worked for me.

[Bansi08]

Thanks Nebula. RegEx function worked for me.

[alt_marsan]

Yeah! I was looking for a solution for a similar situation. Appreciate simple solutions. Thanks, @binuacs 

-alt_marsan