Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Text Field | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |