Excel 2007:Merge or join column contents using ampersand
In Microsoft Excel (2007, 2003 etc.),you can concatenate or merge the contents (text or number values) of two cells (or columns of cells), by creating a formula using ampersand (&).
In Microsoft Excel, merging two cells (or columns of cells) will throw a message “The selection contains multiple data values.Merging into one cell will keep the upper-left most data only.” This implies that merge in excel, does not actually concatenate or merge the contents of the cells or columns of cells and you will infact loose data.So how to concatenate or merge the contents of the cells or columns of cells in Microsoft Excel, whether it be Excel 2007 or Excel 2003 or any earlier version or MS Excel?
Read more
Excell 2007: Split contents in cells of excel worksheets
In Excel (including Excel 2007), contents of cells can be split and displayed across other cells, based on a delimiter.The following is a tutorial on splitting the contents of unmerged cells, in excel worksheets, across multiple columns.
Read more
Office 2007 resource tool kit, free download from Microsoft
Office 2007 resource kit can be freely downloaded by system administrators. Office 2007 resource kit will help them in deploying and maintaining an Office 2007 environment.
You can find technical resources for Planning and architecture for the 2007 Office release, Deployment for the 2007 Office release, Security for the 2007 Office release, and Technical reference for the 2007 Office Release.
Read more
-
Subscribe
Add to favourites