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. |