I need to put text after the value of a referenced cell (=B4'MS')
 

I want to take the value of a cell (say cell B4's value is 05-45612), and
combine that cell into another cell, but add on sereal letters of text, or
even a word. I am looking for the final function to say 05-45612MS, with no
space between the text and the number from B4.

Any help is appreciated! Thanks in advance!
Chris

Just need to put & between them;

=B4&"MS"

"Baugues" wrote in message
...
I want to take the value of a cell (say cell B4's value is 05-45612), and
combine that cell into another cell, but add on sereal letters of text, or
even a word. I am looking for the final function to say 05-45612MS, with
no
space between the text and the number from B4.

Any help is appreciated! Thanks in advance!
Chris

In a helper cell....

=B4&"MS"

OR if MS is in a cell like C4.........

=B4&C4

When happy, copy the helper cell and paste specialvaluesOKEsc.

Then delete the original cell.


Gord Dibben Excel MVP

On Thu, 14 Jul 2005 11:25:02 -0700, "Baugues"
wrote:

I want to take the value of a cell (say cell B4's value is 05-45612), and
combine that cell into another cell, but add on sereal letters of text, or
even a word. I am looking for the final function to say 05-45612MS, with no
space between the text and the number from B4.

Any help is appreciated! Thanks in advance!
Chris