Problem concatenating in Excel
philric
Posted messages
36
Status
Member
-
philric Posted messages 36 Status Member -
philric Posted messages 36 Status Member -
Hello
I have a problem with the concatenate function in Excel. I'm using this formula: =CONCATENATE(J2&J3&CHAR(10)&L2) which works perfectly, the cells J2 and J3 line up and the cell L2 is added below. Now I need to add other cells J4, J5, J6, etc., so I've put this formula =CONCATENATE(J2&J3&J4&J5&CHAR(10)&L2) and it doesn't work anymore. Also, if I modify it by removing J4 and J5 to go back to the original formula, it still doesn't work. To make it work again, I have to press ctrl+z to go back. If anyone has any idea, it would be welcome.
Phil
Configuration: Windows 7 / Firefox 3.6.3
I have a problem with the concatenate function in Excel. I'm using this formula: =CONCATENATE(J2&J3&CHAR(10)&L2) which works perfectly, the cells J2 and J3 line up and the cell L2 is added below. Now I need to add other cells J4, J5, J6, etc., so I've put this formula =CONCATENATE(J2&J3&J4&J5&CHAR(10)&L2) and it doesn't work anymore. Also, if I modify it by removing J4 and J5 to go back to the original formula, it still doesn't work. To make it work again, I have to press ctrl+z to go back. If anyone has any idea, it would be welcome.
Phil
Configuration: Windows 7 / Firefox 3.6.3
2 answers
Hello,
Your formula is correct... That said, what do you want to do with the car(10)? In my opinion, it is not recognized by Excel.
m@rina
--
- "On the office forum, questions concerning office software are asked..."
- "Oh really???"
Your formula is correct... That said, what do you want to do with the car(10)? In my opinion, it is not recognized by Excel.
m@rina
--
- "On the office forum, questions concerning office software are asked..."
- "Oh really???"
If CAR(10) sends me to the next line without problems, the only issue is when I add the other cells J6 or J7 (actually it doesn't matter which cell), then it doesn't work anymore. So this morning I found another solution with this formula
=F6&" "&E6&" "&D6&" "&G6&H6&CAR(10)&F7&" "&E7&" "&D7&" "&G7&H7&CAR(10)&F8&" "&E8&" "&D8&" "&G8&H8&CAR(10)&F9&" "&E9&" "&D9&" "&G9&H9&CAR(10)&F10&" "&E10&" "&D10&" "&G10&H10&CAR(10)&F11&" "&E11&" "&D11&" "&G11&H11&CAR(10)&F10&" "&E12&" "&D12&" "&G12&H12&CAR(10)&F13&" "&E13&" "&D13&" "&G13&H13& CAR(10)&F14&" "&E14&" "&D14&" "&G14&H14&CAR(10)&F15&" "&E15&" "&D15&" "&G15&H15&CAR(10)&F16&" "&E16&" "&D16&" "&G16&H16&CAR(10)&F17&" "&E17&" "&D17&" "&G17&H17&CAR(10)&L6
in cell K6 all my data is retrieved but I think there must be a simpler solution...
for understanding in J6 it is the concatenation of F6&" "&E6&" "&D6&" "&G6&H6
phil
=F6&" "&E6&" "&D6&" "&G6&H6&CAR(10)&F7&" "&E7&" "&D7&" "&G7&H7&CAR(10)&F8&" "&E8&" "&D8&" "&G8&H8&CAR(10)&F9&" "&E9&" "&D9&" "&G9&H9&CAR(10)&F10&" "&E10&" "&D10&" "&G10&H10&CAR(10)&F11&" "&E11&" "&D11&" "&G11&H11&CAR(10)&F10&" "&E12&" "&D12&" "&G12&H12&CAR(10)&F13&" "&E13&" "&D13&" "&G13&H13& CAR(10)&F14&" "&E14&" "&D14&" "&G14&H14&CAR(10)&F15&" "&E15&" "&D15&" "&G15&H15&CAR(10)&F16&" "&E16&" "&D16&" "&G16&H16&CAR(10)&F17&" "&E17&" "&D17&" "&G17&H17&CAR(10)&L6
in cell K6 all my data is retrieved but I think there must be a simpler solution...
for understanding in J6 it is the concatenation of F6&" "&E6&" "&D6&" "&G6&H6
phil