ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell Formular (https://www.excelbanter.com/excel-programming/334944-cell-formular.html)

Ayo

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.



All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com