LinkBack URL
About LinkBacks
Hi, At least 15 rows are data like 2014A1231 TO 201A1245 in Sheet1 -"A" COLUMN. Now if i copy,paste to Sheet2 within a cell it should paste single line, two or three line. I have attached a excel sheet for reference. Thanks.
Hi, At least 15 rows are data like 2014A1231 TO 201A1245 in Sheet1 -"A" COLUMN. Now if i copy,paste to Sheet2 within a cell it should paste single line, two or three line. I have attached a excel sheet for reference. Thanks.
Hi
Are you trying to change the data from a column to a row?
Yes,Please check attachment. Thanks
Hi
Is this something like what you need?
I have merged Cell, within cell all to paste with or without comma.
If you want the result to be like the merged cell but not in a merged cell but a matrix this will do it for you.
Enter the number of columns for the data and the original data will be entered across that number of columns and if another row is required, it will be added. As this stands, the setup will handle up to 20 columns by 200 rows.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi
I found this;
Here is the page I found it on:
Please Login or Register to view this content.
http://stackoverflow.com/questions/8...-cell-in-excel
Unfortunately, this will not work on merged cells because it needs an array formula to activate it.
To use it, load the code and then select a single cell and enter the following in the address bar, =JoinXL(TRANSPOSE(Sheet1!A1:A15);", ") then press cntrl+shift+enter
You can change the separator (commas, spaces) by altering what is between the (red) quotation marks.
Regards
Last edited by Bobsone; 11-25-2014 at 12:49 PM.
Thanks for your reply, But problem is MERGED Cell.
Hi
I agree, the merged cell is the problem.
Unfortunately, I cannot find an answer to this problem. Excluding the labor intensive option of listing every cell in a very long Concatenate string, all the solutions I found do not work in merged cells.
I wonder if someone with the necessary skills (in the Excel Programming VBA/Macro pages) could modify the code and associated formula that I posted earlier.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks