Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Formular
Can anyone help me with this? I am trying to write a cell formula that will
delete the extra commas from "GSM850 CABINET ADD, , , SWAP ANTENNA,". Right now what I am only able to delete the commas if they are at the begining of the statement, i.e., ", , , SWAP ANTENNA," to "SWAP ANTENNA," How do I write a formular that will look in the cell and, if there is any combination of more than one "," together, delete the every "," except for one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell formular | Excel Worksheet Functions | |||
Cell formular | Excel Discussion (Misc queries) | |||
cell formular | Excel Discussion (Misc queries) | |||
Cell formular | Excel Discussion (Misc queries) | |||
How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"?? | Excel Worksheet Functions |