Here is a very useful formula when manipulating data within Microsoft Excel:
=PROPER(A2&" "&B2)
It will tell the software to create a value for the cell using the content of two other cells. It is known as concatenation.
source http://www.mrexcel.com/tip074.shtml
No comments:
Post a Comment