Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to take several columns of data and condense each row into a one
sheet of information to put in a binder. I have tried the following formula, based on Microsoft Office Assistance for combining two or more columns by using a function. It didn't work. Here is the formula I tried: =CONCANTENATE(A1, " ", C1, " ", G1, " ", I1, " ", J1, " ", CHAR(10), L1, " ", CHAR(10), M1, " ", N1, " ", 01, CHAR(10), P1, CHAR(10), Q1, " ", R1, CHAR(10), U1, CHAR(10), W1, CHAR(10), X1, CHAR(10), Y1) This is my first time trying this, and I see by the posts that a lot of you have fantastic experience, so please tell me what I am doing wrong. Thanks, Terri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why won't Excel let me copy and paste my concantenate formula now | Excel Worksheet Functions | |||
concantenate formula? | Excel Discussion (Misc queries) | |||
How do I change the number format within the concantenate function | Excel Worksheet Functions | |||
Concantenate Text with numbers with fixed form | Excel Worksheet Functions |