Can you preserve formatting like bold and color when concatenating

[Andrews493]

Excel 2007 in Windows 10.

I wish to concatenate the text data in 2 columns. That is easy to do using the formula =CONCATENATE(A2, ". ", B2).
My question concerns preserving the existing text formatting during the concatenation.

In my attached example, the content in Column A is formatted as "Bold" and in "Red".
The concatenation results I get using the standard formula are seen in column E. As can be seen the formatting present in column A is lost.

Is it possible to preserve into the concatenated results, the Bold and Red formatting present in column A ?
The desired result is shown in column G.

If yes, how?

Thank you.

[Fluff13]

A formula cannot see formatting, so it cannot be done with a formula.

[Andrews493]

Thank you for the quick reply.

Is there another way to do it in Excel?

The final formatted result will ultimately be transferred into a Word document (in case that makes a difference in the process).

[Fluff13]

You could use a macro, but the cell would have to be text & not a formula.

[Andrews493]

I don't mind using a macro if it will do the trick. But I have no idea how to do that either. I'm not an expert Excel user.

What would the macro contain? Could you give me an example using the data in the spreadsheet I uploaded? That would be terrific.

The end result should be a column containing

a) the formatted text from column A
b) followed by a period and space (. )
c) followed by the text in column B

Thank you so much!

[Andrews493]

Also, the spreadsheet I am working on has 80,000 rows. Can the process be automated?
Thanks.

[Fluff13]

How about

Please Login or Register  to view this content.

[Andrews493]

You are extremely kind and I am very grateful.

But please tell me how do I use the code you created for me? What do I do with it to make it do its magic? Where do I put it and invoke it?

Remember that I am a relative Excel newbie and this spreadsheet has 80,000 rows. How do I implement the solution you so kindly provided?

[Fluff13]

To see how to add & run macros, have a look here
https://www.ablebits.com/office-addi...a-macro-excel/

[Andrews493]

Please ignore. My fault. Macro worked perfectly.

[Fluff13]

Glad to hear that & thanks for the feedback.

[Andrews493]

Sorry to have bothered you unnecessarily. I was busy with other things and did not try the macro till now.

One of the errors I made is that I had the wrong excel file open when I created the macro and the macro was then saved with the wrong name. That is why I could not find it in the Alt F8 dialog, before I discovered my error and searched for it in the "all open workbooks" in the Alt F8 dialog box. I suppose I could now simply create the macro anew with the correct excel file open but is there a way to simply rename or move the macro?

[Fluff13]

You can just copy/paste it to a module in the correct workbook, just remember to save it is as macro enabled.

[Andrews493]

Thank you.

[Fluff13]

My pleasure.