turn this into a function?

[bruizer31]

Hi everyone, I am not sure if this is possible, but if it is i would appreciate your help!

i would like to turn this

Please Login or Register  to view this content.

into a funtion, so that i can just select a cell and it will put it in all three places above.

Please let me know if there are any questions! thanks for yalls help!

[martindwilson]

what do you mean by function? and what does it as it stands intend to do?
at the moment
bob smith
would be bob s
hannibal lecter
would be hannib

[Jonmo1]

^^ +1

We need to first establish what the function is meant to do.
I'm not sure it actually does what you think it does..

[spesner]

I have no idea what to do to get h elp! Perhaps someone will get this and answer me. I am trying to do a mail merge from Excel into wword and on some fields I get data that isn't in the cell. I tried to copy the data into a new sheed and those cells didn't transfer. Am I making myself clear?

[martindwilson]

no i'm afraid not where does mail merge come into this?

[Jonmo1]

Taking a wild guess based on the next thread you posted
http://www.excelforum.com/excel-form...ined-name.html

It seems you want just the text up to the first space...
Getting a first name from a cell containing Firstname Lastname..

In that case, it's
=LEFT(SFList.xlsx!$C$1280,FIND(" ",SFList.xlsx!$C$1280)-1)

[bruizer31]

thank you, is there a way to make it faster though? like where i could click C1280 and have it know to fill that in the entire formula?

[arlu1201]

spesner,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.