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