Unable to copy down formula in excel

I have the following formula:

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

WIth other formulas I create, I am able to drag the formula down the column with the plus at the lower left of the cell, and the B2 changes to B3, B4, etc.

However, this formula does not do this.

Suggestions are appreciated.
exp vgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
I don't see any problem in the formula and you should be able to drag it as well..

Other way to do this is copy the formula... Select your cells where you want to paste and then do ctrl+v it will autofill the number of rows with your formula too..

Saurabh...
0
exp vgAuthor Commented:
Unfortunately, this is not happening, I have tried both ways - dragging and copying.
0
Kanti PrasadCommented:
Hi

I think the problem is not with the formula but the way you might be dragging it. So try putting the same formula in the cells where are you able to do drag other formulas and try it out and if still have an issue attach your xls and I will help you out.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Saurabh Singh TeotiaCommented:
Can you post your sample file so that i can have a look..
0
Kanti PrasadCommented:
Hi

If you cannot copy or drag then it is to do with those cells being protected. Check if those cells are protected and unprotect them.

Go to Review tab on top, high light the formula cell and see if it has select locked cells and select unlocked cells ticked. If not just select both of them and that should do
0
exp vgAuthor Commented:
Please find a sample attached - I tried the review tab and could not find an issue. The first names have been changed for identity.
Name-Separation-with-Spaces.xlsx
0
Saurabh Singh TeotiaCommented:
I went into your file and i was able to drag it without any problem..couple of things...

Click on circle on top or file depending upon your excel version and go to options-->Advance and check have you selected the option of enable fill handle and cell drag and drop..

if your issue is formula doesn't get updated post drag and drop then go to formulas-->calculation options and check whether its on automatic..

If this doesnt work for you then can you post a screenshot of how your screen looks like when you go to the right hand bottom corner to drag it as i didn't found any issue in your file..

And alternatively like i said you can copy paste the formulas as that will works seamlessly..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
exp vgAuthor Commented:
Thank you - the issue was making it automatic. Much appreciated.
0
Saurabh Singh TeotiaCommented:
You are welcome..Always Happy to Help.. :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.