Adding Text without using Ampersand?

[Exxcel Noob]

Hi, I want to combine A1:A85

A1: p
A2: b
A3: p...............

I don't want to type =A1&A2&A3.....................&A85

any formula to combine them faster?

[vlady]

hello
by using udf.

Please Login or Register  to view this content.

=concat(range)

[mmmarks]

Hi,

You can use this one also.

Please Login or Register  to view this content.

[Exxcel Noob]

Hi,

You can use this one also.

Please Login or Register  to view this content.

thank you friend