To fix this, I need to insert actual line breaks, and this is where the CHAR function is useful. Enabling text wrapping isn't going to fix the problem because the line breaks will be random depending on the column width. This works, but notice that everything just ends up on the same line. In addition to cell references, I also need to include "literal text" for spaces and a comma. If I want to create a mailing address using this data, I need to create a formula that uses CONCATENATION to bring the name, street, city, state and zip together. In this video we'll look at a clever way to make this task easier and less error-prone.Ī common example of a situation that requires concatenation is assembling a mailing address from data in separate columns. In the real world, you often need to concatenate values in a way that includes line breaks and other punctuation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |