Left function - more than one word separated by space

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community