How to I combine two cells in Excel (with a space delimiter between)?

I need to retain font (Times & Calibri) and bold and italic.

I tried
=C5&" "&B5
which gives the right answer,
but loses all the font information.

mollwollfumble said:

How to I combine two cells in Excel (with a space delimiter between)?

I need to retain font (Times & Calibri) and bold and italic.

I tried
=C5&" "&B5
which gives the right answer,
but loses all the font information.

This cannot be done using spreadsheet formulae alone because spreadsheet formulae have no control over formatting. The only way I can see it can be done is to use VBA, specifically the Characters object that is a Property of the Range object. This allows one to have different formatting for different parts of the text within a single cell.

If you want to see how it can be done, place some text (not a formula) in a cell. Start Record Macro, select a small block of text within the full text in the Formula Bar, change the format of this text, press Enter, then Stop Recording. You can then inspect the VBA code generated to see how to deal with the Characters Property of the Range object.

Thanks.

I’ve decided that it’s easier to do this in Word rather than Excel.
Import the table into Word – keeps the font.
Then ctrl X ctrl V for each line also retains the font.

mollwollfumble said:

How to I combine two cells in Excel (with a space delimiter between)?

I need to retain font (Times & Calibri) and bold and italic.

I tried
=C5&" "&B5
which gives the right answer,
but loses all the font information.

List of typefaces included with macOS

• Steve Jobs was a Type Face (& Music) Freak
  …he also obsessed over making the personal computers Speak (including the ability to change voices, gender, speed etc.)

I programmed my 1st Mac to respond to ERROR Messages w/the phrase “It’s Not My Fault!” in an aprox of MY Voice
to remind myself to not throw in against the wall while I was still learning the ropes.
…which was funny when I was on the phone with an internet IT worker who was having me run through various fixes,
and my Mac kept responding with “It’s Not My Fault”. After the 4-5th time the IT dude said; “I Didn’t Say It WAS!”

When I told him that was just my COMPUTER’S Error Message.
it was funny hearing the astonished disbelief i his voice as he said, “YOUR COMPUTER TALKS?!?!?” O-8=

Newbie Me, “Yes… doesn’t yours?” (-: o

Ogmog said:

mollwollfumble said:

How to I combine two cells in Excel (with a space delimiter between)?

I need to retain font (Times & Calibri) and bold and italic.

I tried
=C5&" "&B5
which gives the right answer,
but loses all the font information.

List of typefaces included with macOS

• Steve Jobs was a Type Face (& Music) Freak
  …he also obsessed over making the personal computers Speak (including the ability to change voices, gender, speed etc.)

I programmed my 1st Mac to respond to ERROR Messages w/the phrase “It’s Not My Fault!” in an aprox of MY Voice
to remind myself to not throw in against the wall while I was still learning the ropes.
…which was funny when I was on the phone with an internet IT worker who was having me run through various fixes,
and my Mac kept responding with “It’s Not My Fault”. After the 4-5th time the IT dude said; “I Didn’t Say It WAS!”

When I told him that was just my COMPUTER’S Error Message.
it was funny hearing the astonished disbelief i his voice as he said, “YOUR COMPUTER TALKS?!?!?” O-8=

Newbie Me, “Yes… doesn’t yours?” (-: o

Yeah, nah…

furious said:

Ogmog said:

mollwollfumble said:

How to I combine two cells in Excel (with a space delimiter between)?

I need to retain font (Times & Calibri) and bold and italic.

I tried
=C5&" "&B5
which gives the right answer,
but loses all the font information.

List of typefaces included with macOS

• Steve Jobs was a Type Face (& Music) Freak
  …he also obsessed over making the personal computers Speak (including the ability to change voices, gender, speed etc.)

I programmed my 1st Mac to respond to ERROR Messages w/the phrase “It’s Not My Fault!” in an aprox of MY Voice
to remind myself to not throw in against the wall while I was still learning the ropes.
…which was funny when I was on the phone with an internet IT worker who was having me run through various fixes,
and my Mac kept responding with “It’s Not My Fault”. After the 4-5th time the IT dude said; “I Didn’t Say It WAS!”

When I told him that was just my COMPUTER’S Error Message.
it was funny hearing the astonished disbelief i his voice as he said, “YOUR COMPUTER TALKS?!?!?” O-8=

Newbie Me, “Yes… doesn’t yours?” (-: o

Yeah, nah…