Keep formatting and custom formulas.

[Tsorraught]

I have a couple of arrays of cells that have two different text formats and are being put into the same relative cell via "=A1&B1" but "A1" is bold and "B1" is not. I want to keep the bold on "A1" and keep "B1" not bold. Can someone help me accomplish this if it is possible with a custom function (prefered) or some other means?

 

[Sandeep Warrier]

Hi

You cannot do this using regular formulae. You will need code to do this.

For example, if A1 is bold, B1 is regular and C1 = A1 & B1, then try

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Test()<br>    <SPAN style="color:#00007F">With</SPAN> Range("C1")<br>        .Value = Range("A1").Value & Range("B1").Value<br>        .Characters(Start:=1, Length:=Len(Range("A1").Value)).Font.Bold = <SPAN style="color:#00007F">True</SPAN><br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>