combining text

Hi, I am trying to combine the text values of several formulas in addition to adding some text (punctuation) in between. Here is the data that I am trying to combine C14: 2013 C15: Period 6 C16: Week 1 In Cell C13, I would like to have this value returned: "2013 - Period 6, Week 1"...

thanks for taking your time and trying to help out i would like book1 to be the results from book2 plus book3 in a formula <tbody> book1 b c d e f g l t </tbody> <tbody> book2 book3 b b c c g d l e t f </tbody>

thanks for taking your time and trying to help out i would like book1 to be the results from book2 plus book3 <tbody> book1 b c d e f g l t </tbody> <tbody> book2 book3 b b c c g d l e t f </tbody>

I have a couple of arrays of cells that have two different text formats and are being put into the same relative cell via "=A1&B1" but "A1" is bold and "B1" is not. I want to keep the bold on "A1" and keep "B1" not bold. Can someone help me accomplish this if it is possible with a custom...

I must be missing something, I just can figure out what.:( I'm trying to combine a two digit date, i.e. "dd" followed by / then 4 digit hour (which is a number) =text(today(), "dd") & "/" & CO23 (where my hour number is in cell CO23) except when the value in CO23 is <1000. I'd like a leading...