Concatenate
=A1&CHAR(10)&A2
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bruce N." wrote in message ... I have a question about the concatenate function. How do you concatenate two or more cells, so that when they appear in the target cell, the first cell is in the top line, and the second cell is on the next line like if you pressed <alt,<enter within the cell, if you were entering it manually as opposed to using the formula. |
All times are GMT +1. The time now is 06:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com