Home |
Search |
Today's Posts |
#1
|
|||
|
|||
different fonts when I concatenate
I am concatentating a group of Excel cells. The first cell has bold font and
when I concatenate it, the bold disappears. Also, need to put a return in the formula to get second cell to go to next line. Can anyone help me? |
#2
|
|||
|
|||
If you want to CONCATENATE say A1 and B1, put a space and an Alt-Return in a
helper cell, say C1, then =A1&C1&B1 will give you your second line in the target cell........... If you want the BOLD, the only thing I know to do is to set the whole target cell to BOLD. Vaya con Dios, Chuck, CABGx3 "rivgrl85" wrote in message ... I am concatentating a group of Excel cells. The first cell has bold font and when I concatenate it, the bold disappears. Also, need to put a return in the formula to get second cell to go to next line. Can anyone help me? |
#3
|
|||
|
|||
In order to bold the first part of the concatenation, you'll need an
event macro instead of a formula. One way: Put this in the worksheet code module (right-click on the sheet tab and choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("A1, C1")) Is Nothing Then With Range("D1") .Font.Bold = False Application.EnableEvents = False .Value = Range("A1").Text & vbLf & Range("C1").Text Application.EnableEvents = True .Characters(1, Len(Range("A1").Text)).Font.Bold = True .WrapText = True End With End If End Sub Change the cell references to suit. In article , "rivgrl85" wrote: I am concatentating a group of Excel cells. The first cell has bold font and when I concatenate it, the bold disappears. Also, need to put a return in the formula to get second cell to go to next line. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I concatenate information in Excel and keep the number form | Excel Worksheet Functions | |||
space between text strings with concatenate | Excel Discussion (Misc queries) | |||
Excel 2000 crashes when changing fonts. | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Concatenate two halves of a phone number | Excel Worksheet Functions |