Formula Please

  steviegee 08:41 20 Feb 2009
Locked

I have a number in one cell and a word in another. What I want is the the first letter of the word to come after the number. i.e 1.2 is in B1 and Steve is in A1 so that I get 1.2S and so on. Thanks. (Numbers and words vary).

  Picklefactory 09:52 20 Feb 2009

I assume you're talking about an Excel sheet? You could do with spending a little more time on your questions, it is really not very clear what you need.
Do you mean you want a 3rd cell where the number and initial letter are joined together?

  Picklefactory 09:56 20 Feb 2009

If 3rd cell is required option simply place
=B1&LEFT(A1,1) in C1

  steviegee 10:02 20 Feb 2009

I thought it was quite self explanatory. What else could I be referring to. If you don't like the way I put my question don't take the time to answer it!

  Picklefactory 10:30 20 Feb 2009

Thank you, I shan't again.

  VoG II 10:43 20 Feb 2009

Just for the record, this will also work

=B1&LEFT(A1)

  BT 17:27 20 Feb 2009

When people try to help, it really helps if you can clarify points when they ask you to. Your attitude really deserved Picklefactory's response and I don't blame him in the least. You are lucky you got any reply at all if this is how you thank people!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Interview: Camille Walala on her giant 3D installation inspired by childhood funfair visits

Best iPad buying guide 2017

Où regarder le British Open 2017 ?