![]() If you are joining the number 1047 and the string “Maple Street,” the formula “=CONCATENATE(1047,“ ”,“Maple Street”)” works just fine, producing “1047 Maple Street.” The CONCATENATE function converts numbers to text. You must do it by inserting “ ” between the two strings, as shown above, or by replacing that space with a hyphen or other punctuation. For example, if you have the customer’s first name in Column A and the last name in Column B, you could use “=CONCATENATE(A3,“ ”,B3)” to produce a string containing first name and last name.īe aware that when you join two strings, Excel does not insert a space or any punctuation between the two. The CONCATENATE function joins two or more text strings together into one string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |