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