Text Formatter - Split

[drmoyassine]

I am splitting lead name. When I use the option "second to last" to capture all names after the first name in a single field, it returns the 1st name again. Please advise.

 

[Fagun Shah]

Second to last should give you middle name from full name.

Check this -

Do you want to capture everything after First name as a single text? Like "Fagun" and "D Shah" ?

 

[Fagun Shah]

If the above question I asked you is what you're looking for then check this solution -

 

[drmoyassine]

Thanks a lot!