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
|