# Pull from left until Blank (Space)

1. ## Pull from left until Blank (Space)

I'm looking for a formula that pulls the text from a cell unti it hits a space.

I'm using the formula below but keep getting #VALUE results

B1: =LEFT(A1,FIND(",",A1,1))

I know it's not that hard but can't figure it out.

thanks for the help

max

2. ## Re: Pull from left until Blank (Space)

Try

=LEFT(A1,FIND(" ",A1)-1)

3. ## perfect

It worked like a charm. thanks I'll mark it solved and rate you. Strange how my earlier formula used to work now it doesn't..

max

4. ## Re: Pull from left until Blank (Space)

Your first formula is looking for a comma, not a space... and then it would include the comma, so you have to subtract 1 from the Find() result to go back one space...

5. ## Re: Pull from left until Blank (Space)

That's right. I was using it for something else and forgot about the comma. thanks again.......

Max

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1