Skip to main content
Question

Formula Text Field

  • November 20, 2019
  • 0 replies
  • 26 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try this
Trim(Left([Text Box],"\n"))

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