Forum Discussion

JeffElliott's avatar
JeffElliott
Qrew Member
5 years ago

Left function - more than one word separated by space

I have used the "left" function identifying the space after the first word as " ".... to give me the first name in a text field.  So, if it is "Jane doe" then I get "Jane".

If there are three names divided by space, can I use that function to get the first two names?

So if the name is "Jane Smith Doe" I would get "Jane Smith?"


------------------------------
Jeff Elliott
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    If you want everything except the last name, then you can use

    NotRight([my name field]," ")

    That will work for any number of names.  So the last name would be

    Right([my name field]," ") and everything else would be the first formula

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------