![]() ![]() If you have additional product descriptions in column A and you placed this formula in cell B1, just copy the formula down as many cells as necessary. This formula locates every space in the text and replaces them with dashes. Thus, assuming your original product description is in cell A1, you could use the following: ![]() At its most simple, SUBSTITUTE is used to replace one character in a text string with a different character. ![]() Perhaps the easiest way to accomplish this task, using a formula, is to rely on the SUBSTITUTE function. She knows she could use Find and Replace, but would prefer to use a formula to do the replacements. She needs a way to replace all the spaces between words with dashes. Viv has a worksheet that contains lots of product descriptions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |