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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top