Concatenating text

[SysDupe123]

I'm trying to concatenate the values of two cells into another. I can write a formula for that, but I wanted to know if there was a function that can set the font size so that one value can be larger than the other.

 

[SysDupe123]

Opps, I forgot, it is Excel 2003!

 

[PeterMoran]

Hi,

I don't think you can do it on a formula, but you can do it on text by going into edit mode, selecting the text to have the format changed, and then making the changes via the formatting toolbar, which you will find is active. If you try this on part of a formula you will find the formatting options greyed out.

What you really need is a Text function which could be inserted as part of the formula, or possibly a User Defined Function to do what you want (If it can be done via a UDF).

Good Luck,

Peter Moran

 

[mintjulep]

There is no native function for this.

Possibly this could be done with a VBA UDF, but my quick try proved unsuccesful.

 

[yogia]

Hi SysDupe123:

No native function in EXCEL for what you want. I had a little play -- with a UDF, I could only concatenate, but to change the font size in midstream, I had to use a SUB.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com