Text concatenation while preserving the text formatting

Question

Hello,

I am currently working on Excel with lists of animal species. I have a column with the French name and one with the Latin name.
To save time and space, I would like to "merge" these two columns into one. I am using the formula =A1&" "&B1 to obtain a cell with the content of the two others.

My question is the following: the Latin names of my species are in italics, how can I ensure that this text remains italicized after concatenation? I end up with both names in a single cell, but all the text has standard formatting. Thank you in advance

Configuration: Windows 7 / Firefox 48.0

Raymond PENTIER · Answer

Hello.

It's not possible with the classic functions and tools of Excel.

But it is not impossible that a solution can be found in VBA...

--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)

ccm81 · Answer

Hello  You will have to go through a macro http://www.cjoint.com/c/FIbl1HPQBun  Best regards

v3nny01 · Answer

Sure, thank you :) Actually, I need to create a macro that says "the text in parentheses should be italicized" or something like that? I don't know anything about VBA, but I have to start somewhere :)

ccm81 · Answer

You didn't mention parentheses
To clarify, can you send a part of the file on cjoint.com and attach the obtained link to your next message. Don't forget to add explanations and examples of the expected result

1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file
3) Scroll down to the bottom of the page and click on [Create the Cjoint link]
4) After a few seconds, the second page will display with the link
in blue underlined; select it and click "Copy"
5) Return to your discussion on CCM, and in your response message
paste it.

Best regards

v3nny01 · Answer

Hello,  Here is the link https://www.cjoint.com/c/FIgnvelnQxh  The proposed macro works well but only for simple names. Thank you

ccm81 · Answer

The modification  Const sep = "("Public Sub OK()Dim plage As Range, cel As Range, s As String, rs As LongSet plage = SelectionIf plage.Columns.Count <> 1 Then Exit SubFor Each cel In plage s = cel.Value & " (" & cel.Offset(0, 1).Value & ")" rs = InStr(1, s, sep) With cel.Offset(0, 2) .Value = s .Characters(rs + 1, Len(s) - rs).Font.FontStyle = "Italic" End WithNext celEnd Sub Best regards

v3nny01 · Answer

But thanks anyway for your help, I think I'm going to manage as best as I can, I don't have time to mess around too much with the macros XD  Sorry and thanks again

ccm81 · Answer

I find myself with the original text and parentheses in italics next to it ??? If I send you a proposal, it works (in principle), so it’s certainly a mistake somewhere!  I think I’ll manage as best I can, I don’t have time to fiddle too much with the macros XD It’s up to you!  http://www.cjoint.com/c/FIgojlvEk1q  Regards

Text concatenation while preserving the text formatting

8 answers

After reinstall-computer: data recovery

Free resource: educational games from cp to terminale

Windows update updates kb

Slowdowns during video sharing on zoom

Pc compatible, but windows 11 update not possible.

Device security

Headphone adapter for galaxy s24

Configure voicemail on built-in landline

How to scan a qr code with a samsung

Set the number of rings on landline