combining text

  1. andrewb90

    combining text and formulas

    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"...
  2. Y

    formula for combining

    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>
  3. Y

    combining

    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>
  4. T

    Keep formatting and custom formulas.

    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...
  5. K

    Combining numbers, text , and numbers with leading 0

    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...

Some videos you may like

This Week's Hot Topics

Top