Help with Concatenate

[dreamer610]

Hi,
I was wondering if anyone could help me this. I have three fields that I want to Concatenate into one. Now I've used the Concatenate function to do this. However it does not seem to transfer styles, such as bold, into the new cell. The data in the first two cells is bold, and the last cell is not. Is there a way I can transfer the styles over as well?

Thanks in advance

 

[pcdaveh]

You'll need to use vba code this will do what your talking about with a little tweeking:
Sub Testit ()
With Worksheets("Sheet1&quot.Range("A1&quot
.Value = "abcdefg"
.Characters(3, 2).Font.Bold = True
End With

End Sub

 

[dreamer610]

Thanks I'll give it a shot.