Hey guys,
Can you please suggest to me a formula that will remove a text after multiple characters ( ‘’,‘’ ‘’/‘’ ‘’ - ‘’ ‘‘and’’ ‘’&‘’ ‘’;‘’ ‘’(‘’.
I already found on this Forum the formula that removes a text after one single character,
LEFT(
{Colum...
I have one more question, do you know how can I add to this formula one more formula that will make all words begin with capital letters, and other letters will be small?
I used before for other columns this formula for lowercase and uppercase letter...
@Nathaniel_Granor thank you very much for your advice, but I don’t need just to extract those characters I also need to extract the text after those characters:
COO and Director - COO
COO/Director - COO
COO - Director - COO
COO, Director - COO
