merge - columns
hi,
i have a list of data in columns. i would like to merge the data from certain adjacent cells into one cell...but it is important that none of the data is lost (as does occur when using 'merge' function) does anyone know of a macro/way of achieving this? i would be most grateful for any help |
merge - columns
Try CONCATENATE function
For example in E1: =CONCATENATE(A1,B1,C1,D1) will merge/join the contents of these cells together. To add spaces between value: =CONCATENATE(A1," ",B1," ",C1," ",D1) Is this what is required? "jeff" wrote: hi, i have a list of data in columns. i would like to merge the data from certain adjacent cells into one cell...but it is important that none of the data is lost (as does occur when using 'merge' function) does anyone know of a macro/way of achieving this? i would be most grateful for any help |
All times are GMT +1. The time now is 11:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com