Text String Question
Hello All,
Quick question I just need this 46 digit number before  Retailer in this column but cannot get my formula to work since what I am pulling ranges from 46 digits.
For example In my new column trying to create, I would just need 59552 from59552 Martin Tractor or 178874 from 178874  BROOKS TRACTOR INCORPORATED
Best Answer

Hi @ConnorForm
If all your cells have a space after the 46 digit number then you are in luck. You can determine the length of the text to extract based on the position of the space.
=LEFT(Retailer@row, FIND(" ", Retailer@row)  1)
The FIND will return the position of the space. Subtracting 1 will give the number of characters before the space. Using this as the number of characters part of the LEFT function will return just the characters to the left of the space.
Like this:
Answers

Hi @ConnorForm
If all your cells have a space after the 46 digit number then you are in luck. You can determine the length of the text to extract based on the position of the space.
=LEFT(Retailer@row, FIND(" ", Retailer@row)  1)
The FIND will return the position of the space. Subtracting 1 will give the number of characters before the space. Using this as the number of characters part of the LEFT function will return just the characters to the left of the space.
Like this:
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 61 Global Discussions
 46 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!