Skip to main content
Header expanded
Link
Sergej Utko
  • 22.1k
  • 11
  • 60
  • 88

Formula field for getting a fieldfirst and last word from the string

Tweeted twitter.com/#!/StackSalesforce/status/398433963888607232
Source Link
Tomas Q.
  • 179
  • 1
  • 2
  • 5

Formula for a field

i need a help with a formula. I want to create a formula that will select the firts name and the two last names and input them in a box. ps: i m portuguese and we have a lot of family names thats why i need this Imagine:

First Name: Tomas Last Name: ferraz amorim silverio montenegro

And the result like this Tomas Ferraz Montenegro

And the name can t excess a max of 27 caracters

Thank you very much