Formula to remove text before delimiter?

1

Hello,

I’m trying to create a column with a formula that removes text from another column before the delimiter, for example

Column A has “testing - complete”

I want a formula in column B that will output just the word “complete” after the ‘-’.

Is this possible?

Thank you!

2

Dear @Nikki_Donkin, welcome to the community :handshake:

This should do the job:

image

3 Likes
3

Hi @Nikki_Donkin,
@Jean_Pierre_Traets solution works very well :+1:

In case this is relevant, I’d just add the Trim() function at the end to strip out potential whitespace(s) after “-”.
Therefore one of the following:

  1. thisRow.A.Split(" - ").Last() // Ugly...
  2. thisRow.A.Split("-").Last().Trim() // Better
  3. thisRow.A.RegexReplace(".*-\s", "") // Alternative

Cheers

5 Likes
4

Perfect, thank you both so much!