can I enter text as part of an excel formula, eg: xxx boxes
F Fred Smith Mar 5, 2008 #2 Yes, just put it in quotes. Somthing like: =a1&" boxes" You can also set up a custom format to achieve the same thing. If you want to format the way A1 appears, use something like: =text(a1,"0.00")&" boxes" Regards Fred.
Yes, just put it in quotes. Somthing like: =a1&" boxes" You can also set up a custom format to achieve the same thing. If you want to format the way A1 appears, use something like: =text(a1,"0.00")&" boxes" Regards Fred.
