• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help in CONCATENATE formula

Jawaharp

New Member
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.
 

Attachments

GraH - Guido

Well-Known Member
Alternative can be simply like this.

Dataformulatext
100 feet Road100 feet Road=B1&A2
3RDLY SOLUTIONS100 feet Road3RDLY SOLUTIONS=B2&A3
AAKASH COMMUNICATION100 feet Road3RDLY SOLUTIONSAAKASH COMMUNICATION=B3&A4
Abie Associates100 feet Road3RDLY SOLUTIONSAAKASH COMMUNICATIONAbie Associates=B4&A5
Addon Communications100 feet Road3RDLY SOLUTIONSAAKASH COMMUNICATIONAbie AssociatesAddon Communications=B5&A6
 
Top