LinkBack URL
About LinkBacks
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
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
Last edited by maxthebear; 01-05-2010 at 03:01 PM.
Try
=LEFT(A1,FIND(" ",A1)-1)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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
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...
Last edited by NBVC; 01-05-2010 at 03:06 PM.
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
Register To Reply
Bookmarks