Calling all Excel experts...

Overview Chat Bike Members News Women

This topic has 11 replies, 6 voices, and was last updated 14 years ago by muddy_bum.

Viewing 12 posts - 1 through 12 (of 12 total)

Calling all Excel experts…
tyger
Free Member

Is there an easier formula I can use other than this:-

=+CONCATENATE(+LEFT(B4,7),"*")

To do the same thing?

Many thanks as always.

Posted 14 years ago

ctznsmith
Free Member

No

Posted 14 years ago

geoffj
Full Member

Depends what you are trying to achieve, but that looks pretty simple to me.

Posted 14 years ago

dave_aber
Free Member

=LEFT(B4,7)&"*"

Posted 14 years ago

TheSouthernYeti
Free Member

Urrrgghhh what the hell are you doing with the '+' sign!

Posted 14 years ago

ctznsmith
Free Member

Does the "&" join two text strings?

You learn something new everyday. 🙂

Posted 14 years ago

TheSouthernYeti
Free Member

Yes, and please stop putting plus signs in front of your formulas.

Posted 14 years ago

ctznsmith
Free Member

I don't put plus signs that was the OP! 😉

Posted 14 years ago

TheSouthernYeti
Free Member

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))

Posted 14 years ago

LittleTones
Free Member

Oh come on , its bad enough having to w**k with excel, not here as well!

Posted 14 years ago

TheSouthernYeti
Free Member

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!

Posted 14 years ago

muddy_bum
Free Member

W**king over Excel at 10 at night will make you blind I'm sure!!

Posted 14 years ago