Learning Excel Text values in formulas are limited to 255 characters excel

YOU ROCK !!! Thanks for your wonderful SOLUTION !!! I read several very complex solutions impossible for excel novice like me !!! Have a great day !!!

Dude, loved the idea, but do you know how to solve it for the hyperlink forula? I set up automatic e-mails trough hyperlink formula and I referenced cells in excell so that I cal write the email in excel, for some reasuon, no matter where I put my "&" in the formula or in the texts (within the cells), the hyperlink formula keeps giving the "VALUE!" error after I type my email in the cells

great job bro

Thanks lot sir...

Thanks a lot ..awesome stuff