ExcelBanter - merge cell data

ExcelBanter (https://www.excelbanter.com/)

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

- - merge cell data (https://www.excelbanter.com/new-users-excel/143258-merge-cell-data.html)

change 04/02/07 to 040207[_2_]

merge cell data

merge three cells

Gordon

merge cell data

"change 04/02/07 to 040207"
wrote in message ...
merge three cells

Depending what the cells contain, you could use Concatenate....

Gord Dibben

merge cell data

=A1&B1&C1

Gord Dibben MS Excel MVP

On Fri, 18 May 2007 04:59:01 -0700, change 04/02/07 to 040207
wrote:

merge three cells

All times are GMT +1. The time now is 09:13 PM.