PC Review


Reply
Thread Tools Rate Thread

How to combine a symbol and a formula

 
 
Heine
Guest
Posts: n/a
 
      26th Jun 2007
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

 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      26th Jun 2007
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
 
Reply With Quote
 
Heine
Guest
Posts: n/a
 
      26th Jun 2007
On Jun 26, 11:51 am, Heine <h...@sparinvest.dk> 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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine a VLOOKUP formula and a NETWORKDAYS formula? Tracy Microsoft Excel Worksheet Functions 2 15th Oct 2009 04:14 PM
Number Format - Combine Currency Symbol & Scale Mark Nethercott Microsoft Excel Programming 2 24th Jun 2009 09:54 PM
$ symbol in a formula RAB2685 Microsoft Excel Worksheet Functions 4 18th Sep 2008 10:44 PM
Using a Symbol in a formula. =?Utf-8?B?SkIgaW4gS2Fuc2Fz?= Microsoft Excel Misc 3 10th Jun 2005 08:07 PM
I need to combine a symbol with a letter for medical terminology =?Utf-8?B?bWVkaWNhbGNoaWNrZW4=?= Microsoft Word Document Management 5 24th Mar 2005 08:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:30 PM.