ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Easier way to concatenate a row? (https://www.excelbanter.com/excel-worksheet-functions/207287-re-easier-way-concatenate-row.html)

Ron Rosenfeld

Easier way to concatenate a row?
 
On Tue, 21 Oct 2008 16:30:01 -0700, Allison
wrote:

This is even better than I thought it was when I said thanks earlier. It
works even if the cell contents are text or something else besides number or
named ranges. Thank you very much.


You're welcome. Thanks for the feedback.

By the way, if you haven't noticed, unlike the worksheet concatenate operator
or function, this UDF will retain any cell number or date formatting in the
output.
--ron


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com