Trind to Trim Names to just First Last

[kyle]

I am trying to use text to columns - or Trim Formula, but have been successful in using space a delimiter as it separates the name before the team initials. 

[jrgo]

@kyle  the workflow file you attached didn't include any data so unable to see the issue and I'm having difficulty in understanding what you described but thinking it would make sense should the data file have been included.

I don't think you need to share the actual data file, but if you share a few examples of what the value looks like before and what your desired result would be, that'd be helpful with sharing a possible solution for you.

Unrelated to your question, but this question seems that it'd be a better fit in the Designer discussion board.

[TimN]

For the "Text to Columns" tool use '\s' as the delimiter.  This is how you represent a space in the tool.