Ask Search:
Laura MondayLaura Monday 

Formula to use only part of a text field

I have a text field and I just want to return the value of everything before the first space. It's not always a set number of characters in. Any ideas of a formula to use? Thanks in advance!

For example:
12345 Sample Info  --- I would want "12345" returned
Best Answer chosen by Laura Monday
Deepak AnandDeepak Anand
Try this = 
LEFT(Text_Field__c, FIND(' ', Text_Field__c) - 1)

All Answers

Deepak AnandDeepak Anand
Try this = 
LEFT(Text_Field__c, FIND(' ', Text_Field__c) - 1)
This was selected as the best answer
Laura MondayLaura Monday
That worked PERFECT! Thank you!