merge cell and padding
I'm copying a spreadsheet and in the process I need to merge 3 columns into
1. The first two need to be padded with 40 characters. Is there a way that this could be done at a sheet level instead of interatiing through every row? Thanks. Dwight |
merge cell and padding
If you mean concatenate, then yes. You can select the range of cells to
contain the formula. Enter it in the formula bar so it is correct for the activecell (using relative addressing), then hit Ctrl+Enter rather than enter. -- Regards, Tom Ogilvy "dwight" wrote in message ... I'm copying a spreadsheet and in the process I need to merge 3 columns into 1. The first two need to be padded with 40 characters. Is there a way that this could be done at a sheet level instead of interatiing through every row? Thanks. Dwight |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com