ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel (https://www.excelbanter.com/new-users-excel/191605-excel.html)

Shawn

Excel
 
How do I combine the data in several identical records into one?

Sandy Mann

Excel
 
What kind of data? If text thensomething like:

=A1&B1&C1

or

=A1&" "&B1&" "&C1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Shawn" wrote in message
...
How do I combine the data in several identical records into one?





All times are GMT +1. The time now is 01:10 PM.

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