| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for Replacing Text in a String?
I'd like to make a formula (NOT USING VBA) that would replace, in a list of
characters, all instances of the following with nothing: , , (That's a comma followed by a space, followed by a comma, followed by a space.) If possible, the formula would also eliminate the last character in the string if it's a comma. Thanks, Dave -- Please delete "ANTI-SPAM" from email address David Godinger: Go player, student of Mahatma Gandhi, the Buddha, and Dr. Martin King |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing a formula with the actual string or number | Excel Discussion (Misc queries) | |||
| Extracting and replacing the first word in a String of text | Excel Worksheet Functions | |||
| Replacing numeric X-axis labels with corresponding text string | Excel Discussion (Misc queries) | |||
| replacing text within a formula | Excel Worksheet Functions | |||
| Replacing a value within a string using a formula | Excel Programming | |||
Threaded Mode
