I have thousands of lines of text in cells of columns B and C in excel sheet1. There are empty cells in some places.
I am trying to concatenate the text one below another using the formula =B2&CHAR(10)&C2 in the respective cells in D but the formula is not working.
Please help.
Last edited by zeo1; 07-10-2021 at 02:30 AM.
Make sure that the cells in column D have "Wrap Text" turned on.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
No sir it is not working. Is there a VBA for it?
Try:
Please Login or Register to view this content.
Last edited by Mumps1; 07-10-2021 at 09:09 AM.
It is working but the VBA can not copy the complete data in the cells of D sir.
I'm not sure what you mean. Please clarify in detail bycannot copy the complete data in the cells of D
Sir, I think the cell data limit is the issue.
Sir, I copied the data in B and C from text files in a folder.
Can we do it? If it makes sense
1. If I can add the b text file data in the C text file (by giving the address of the files in C and D), then that will also work for me. or
2. If I can add the b cell data in the C text file (by giving the address of the files in D) also will work for me.
Last edited by zeo1; 07-13-2021 at 12:46 PM.
What do you mean by the the cell data limit. Can you post a few examples of your data and explain how it is not working for you?
By cell data limit I mean the maximum number of characters an excel cell can accommodate. Is it clear sir?
I am not sure about the issue just my blind guess.
Are you saying that your cells contain more than 32,767 characters?
I think yes. Is there any way to check the number of characters in a cell?
This formula will give you the number of characters in cell A1:
=len(A1)
=LEN(D2) is showing 32767. Now ?
D2 has reached its maximum length. Please explain in detail what you are trying to achieve.
Sir I am trying to merge the data in two text files to get the data in a single file (one below another).
I thought the above way would be easy for me.
I'm afraid that you will be limited by the maximum number of characters in a cell allowed by Excel.
Sir by giving the two file location one in C and another in D to merge and giving a folder/name.text in E, can we get the merged file using VBA? Not sure.
It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file. It would also help if you could post copies of the two files to be merged.
Sir, here is the example file. Is it clear?
Thank you for the file. However, the sheet contains only the file paths of the two files to be merged and the output file. I need you to post the actual files themselves so that I can see the contents of the files and then you need to explain in detail referring to specific cells, which contents from each file you want to merge and where in the output file you want to place the merged contents.
I do not want to disclose the files in public so I wrote a private message, sir. I want to add the complete file1 data below complete file2 data and neet to get the out put in a new file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks