How about =LEFT("||||||||||||||||||||||||||||||",A1) where A1 has a numeric
value
---- until you buy Excel 2007 that has the feature you want.

You should have an alias email address when sending messages to newsgroups.
Otherwise, crawlers will find you and send spam.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ChemicalJasper" wrote in message
ups.com...
I want to know if it is possible to format text within a formular?

Using the =REPT("I",cell) formular - ( from Juice
Analytics)
you can effectively draw a small bar chart in a sigle cell.

What I want to do is combine three cells to a single bar, but have each
cell value formatted as a different colour, within the single.

so formular currently is,

=(REPT("|",cell 1))&(REPT("|",cell 2))&(REPT("|",cell 2))

What I want to do is (but obviously the below does not work - is there
a format to do this?)

=([Red]REPT("|",cell 1))&([Blue]REPT("|",cell
2))&([Green]REPT("|",cell 2))