| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace Comma with Dash
Hello,
Please can someone explain how I can replace commas with a dash/ hyphen. For example cell A1 contains "ABC,DEF,GHI". I would like cell B1 to display "ABC-DEF-GHI". I attempted to use REPLACE(A1,FIND(CHAR",",A1),1,",") but this only replaces the first comma. I need to cound how many comma's are in the text and then replace them. I know I could you a find and replace but I need a formula. The number of commas in the text will vary. Sometimes there are 2 other times there are none. Thanks, Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace Comma's with Dash | Excel Worksheet Functions | |||
| replace dash in a number sequence | Excel Worksheet Functions | |||
| How to substitute a comma with a newline char using Replace. | Excel Discussion (Misc queries) | |||
| Replace Error with a Dash | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Threaded Mode
