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

B

Baugues

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
 
G

Gord Dibben

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 special>values>OK>Esc.

Then delete the original cell.


Gord Dibben Excel MVP
 
Top