Tuesday, 4 September 2012

& [ampersand] - Excel

Concatenates cells contents
Type:   =A1&B1
e.g.      =firstname&lastname
                       JoeBlogs

 
Text can be inserted into the formula by using speach marks" - "
Type     =A1&" - "&B1
e.g        =firstname&" - "&lastname
                          Joe - Blogs


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)