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

Is my home wi-fi network not the same as my box? is that normal?

Dvd player: "temporary ban"

Many f a i offer a €2 subscription and the card €1"

Cubbie web search

Quick launch bar

Is it possible to contact a seller on amazon

Illegal car wash: fine up to 450 euros in france

Forgot password

Google news (google news)

Android smartphone hacked