Drag CONCATENATE Formula or other formula till last cell in the spreadsheet

Hello Excel Experts,

I've a spreadsheet were I have a values from cell A2 to A108443 (see attached spreadsheet as a sample).

In B2 and C2 I've inserted Double Quotes and in D2 a Vertical.

In E2 I added a formula i.e. =CONCATENATE(B2,A2,C2,D2).

In F2 (into single cell) I want all the values.

I assume there are some limitations into Excel.

When I try to drag the Formula F Column till the end, I get an Error messsage as "formula is too long formulas may not exceed 8192 characters".

It will be great even if we will be able to break this into 25,000 cell values into single cell.

This will be a great help...

Regards,

Hello,

I have a list of thousand and thousands of Part No.

Say for example a have a list of 1 thousand parts and want to extract report from our Internal application for all this thousand part no. I cannot manually search and extract report part by part (which will be very time consuming).

Into our Internal application I use, we have an advanced option to search and extract report for multiple parts at one instance.

And as stated in my last thread, I've more than 1 lakh part list.

It would be great if we can right a macro and get all the list into Word document or text document.

For e.g. the output should be - (100|200|300|400|500|600|700|800|900|1000|)

Thanks !

I don't understand what numbers you want in the list. In your file you just have a list of numbers from 1-108442. How did you come up with the sample output in your last post?

And as stated in my last thread, I've more than 1 lakh part list.

What does "lakh" mean? Are you using Google translate?

Request if somebody can suggest a option for concatenating more than the limit of 32767 characters in a cell.