Help in CONCATENATE formula

[Jawaharp]

Hi Friends,

I have more than 1 to 1000 data have to concatenate like 1&2&3&4

Sample file has enclosed for your reference.

and mentioned the output also..

Pls Help..


Thanks.

 

[Peter Bartholomew]

The simplest solutions can only be achieved with modern versions of Excel

 

[GraH - Guido]

Alternative can be simply like this.

Data		formulatext
100 feet Road	100 feet Road	=B1&A2
3RDLY SOLUTIONS	100 feet Road3RDLY SOLUTIONS	=B2&A3
AAKASH COMMUNICATION	100 feet Road3RDLY SOLUTIONSAAKASH COMMUNICATION	=B3&A4
Abie Associates	100 feet Road3RDLY SOLUTIONSAAKASH COMMUNICATIONAbie Associates	=B4&A5
Addon Communications	100 feet Road3RDLY SOLUTIONSAAKASH COMMUNICATIONAbie AssociatesAddon Communications	=B5&A6