Hi

I would like to have a formula that is =a1&a2.......a100. Is there a shortcut or do I need to manually key in the whole string?

thanks