PDA

View Full Version : Partial format of cell



enfantter
04-13-2010, 12:24 AM
hi all,

Im trying to combine to cells in excel which both contain text (eg cell A1 and B1)

im doing something like
=A1&" "&B1

the thing is though that i would like to make the part that comes from A1 bold - is this not at all possible ?!

enfantter
04-13-2010, 12:25 AM
originally i was trying to do something like,

=text(a1;[bold])

but i doesnt seem to work

Aussiebear
04-13-2010, 01:54 AM
With Range("A1")
.Font.Bold
End With

enfantter
04-13-2010, 01:55 AM
is this possible to do without vba

mdmackillop
04-13-2010, 02:08 AM
You can do it "manually" but not by adding to the formula