![]() ![]() ![]() ![]() Actually, that would give you MrChristopherPhin, so the formula needs to be =C2&" "&B2&" "&A2 to concatenate in some spaces. In column D you could use the formula =C2&B2&A2 to produce, for example, Mr Christopher Phin. Let's say you have a list of surnames in column A, forenames in B, and titles in C. Note that it's not adding them mathematically – if you have the value 3 in one cell and 4 in another, using '&' would produce the result 34 – but it's handy for grouping stuff. The ampersand symbol (&) has a special function on a spreadsheet, and that's to bring together values from other cells into one. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |