ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to combine a symbol and a formula (https://www.excelbanter.com/excel-worksheet-functions/147962-how-combine-symbol-formula.html)

Heine

How to combine a symbol and a formula
 
Hi everybody,

How can you combine a symbol and a formula into one?

I have a coloured square (a symbol or a drawing) I want to put in
front of a formula. I have tried combining with '&' but without luck.
I does put the symbol in front but not as the square. It shows
something that looks like a russian letter.

any thoughts?

best regards
Heine


Dave Peterson

How to combine a symbol and a formula
 
Formulas don't support this kind of character by character formatting.

Maybe you can just use two columns?

Heine wrote:

Hi everybody,

How can you combine a symbol and a formula into one?

I have a coloured square (a symbol or a drawing) I want to put in
front of a formula. I have tried combining with '&' but without luck.
I does put the symbol in front but not as the square. It shows
something that looks like a russian letter.

any thoughts?

best regards
Heine


--

Dave Peterson

Heine

How to combine a symbol and a formula
 
On Jun 26, 11:51 am, Heine wrote:
Hi everybody,

How can you combine a symbol and a formula into one?

I have a coloured square (a symbol or a drawing) I want to put in
front of a formula. I have tried combining with '&' but without luck.
I does put the symbol in front but not as the square. It shows
something that looks like a russian letter.

any thoughts?

best regards
Heine


this works: =" "&formula

then the space is made to fill in the drawing.



All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com