R rhett miller Jun 10, 2004 #1 Is it possible to merge multiple columns of data into on column after using the "Text to columns" function?
Is it possible to merge multiple columns of data into on column after using the "Text to columns" function?
C Chip Pearson Jun 10, 2004 #2 Rhett, There is no built in way to do this. You can use a formula like =A1&B1&C1 or =A1&" "&B1&" "&C1 to combine cells A1, B1, and C1. Copy this formula down as far as you need to go. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Rhett, There is no built in way to do this. You can use a formula like =A1&B1&C1 or =A1&" "&B1&" "&C1 to combine cells A1, B1, and C1. Copy this formula down as far as you need to go. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
K Ken Wright Jun 10, 2004 #3 With your data in Cols A:E, in say cell F1 put the following and copy down =A1&B1&C1&D1&E1 or =A1&" "&B1&" "&C1&" "&D1&" "&E1 When done, select Col F and copy and then paste special as values - You can now delete Cols A:E
With your data in Cols A:E, in say cell F1 put the following and copy down =A1&B1&C1&D1&E1 or =A1&" "&B1&" "&C1&" "&D1&" "&E1 When done, select Col F and copy and then paste special as values - You can now delete Cols A:E
