I have this data in a text field, I need to extract just the first and last name at the start of this text:
I tried:
Left(Text Box],"Email") returns first letter of first name. Any help would be appreciated.
Billy Bob
Email: Fake@Fake.com
Mobile Phone: (419) 123-1234
HOMEOWNER INFO
Name: Billy Bob
------------------------------
ProjectsForce
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.