concatenate formatting

  1. A

    Concatenate and bold

    Hi, i am ccocatenating 2 columns that are I and J, and i want the test in column I to be bold. how can i do it?
  2. S

    Keep font size in concatenation?

    The font size in one column of my data is different from the others. How can I keep the correct sizes when the data is concatenated? Thanks!
    • sammipd
    • Thread
    • concatenate formatting data font font formatting size
    • Replies: 3
    • Forum: Excel Questions
  3. L

    Concatenating but having small error

    I am trying to concatenate date into from 10 columns into 3. The code that I have to concatenate columns K to Q are as follows =IF(ISBLANK(L576),TEXT(K576,"dd/mm/yy"),TEXT(K576,"DD/MM/YY")&" - "&TEXT(L576,"DD/MM/YY")) =IF(ISBLANK(N576),TEXT(M576,"hhmm"),TEXT(M576,"hhmm")&" -...
  4. A

    Concatenate but keep the font format

    Good day, I’m trying to concatenate the text from a number of cells. But I want the first cell’s text to be bold. A1 Class: B1 Mr. Muller I want it displayed as: Class: Mr. Muller I'm only starting with VBA. And having lot of trouble. Thanks a lot.
  5. K

    Formatting Date to MM-DD-YY while using CONCATENATE

    Hello everyone, I am having difficulties with a date properly formatting while I am using the CONCATENATE formula. I have a date in cell B1, which is formatted correctly, and there are also multiple unrelated cells from B2 - B10 that are "input" cells. I am using A15 to with a concatenate...
    • kbdavis11
    • Thread
    • concatenate concatenate date concatenate formatting date date formatting
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top