Forum Discussion

atchaya17's avatar
atchaya17
Copper Contributor
Jun 24, 2022

excel

               I have value in each cell. I want to add comma at the end for example Structured QUery Language, Science, Social. So I can count each cell value with the help of comma. How to add comma I have 20000+ columns and each cell has 20 to 30 values.Please let me know

admin
developer
microsoft teams
office 365
training
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Jun 24, 2022

    atchaya17 

    Hello atchaya17,

    I hope the attached example document is what you are looking for. Otherwise, it will give you the inspiration you need to find your solution.

    =SUBSTITUTE() is the solution to your problems.

     

    best regards

    dscheikey

     

    • atchaya17's avatar
      atchaya17
      Copper Contributor
      Jun 24, 2022
      also if i have blank in my cell how to change the syntax
      • dscheikey's avatar
        dscheikey
        Bronze Contributor
        Jun 24, 2022
        Should existing blank lines in the cells remain? Please describe exactly what you want as an outcome and what the final result should be. This is the only way to help.

Resources