Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Is there an easier formula I can use other than this:-
=+CONCATENATE(+LEFT(B4,7),"*")
To do the same thing?
Many thanks as always.
No
Depends what you are trying to achieve, but that looks pretty simple to me.
=LEFT(B4,7)&"*"
Urrrgghhh what the hell are you doing with the '+' sign!
Does the "&" join two text strings?
You learn something new everyday. 🙂
Yes, and please stop putting plus signs in front of your formulas.
I don't put plus signs that was the OP! 😉
Sorry, I'd assumed you were the OP, too busy answering excel queries in my real job, ahhh formula love.....
=SUM(INDEX(RevenueSupplier,,CK$1))
Oh come on , its bad enough having to w**k with excel, not here as well! [img] 
[/img]
LittleTones, what's worse is feeling obliged to answer excel based queries on here at 10 at night when you've been developing budgeting models in VBA for 12 hours that day!
W**king over Excel at 10 at night will make you blind I'm sure!!