Forum Discussion

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

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.xlsx9 KB

atchaya17
Copper Contributor
Jun 24, 2022
also if i have blank in my cell how to change the syntax
- 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.
  - atchaya17
    Copper Contributor
    Jun 24, 2022
    I mean , each cell there was 5 to 6 values when I used for formula it worked, but in some cells it has empty cells, When I used for syntax it added as comma in the empty cell dscheikey in this example 2nd cell dont have any values but it taken as comma.
atchaya17
Copper Contributor
Jun 24, 2022
I got the answer, Thank you so muchhhhh
atchaya17
Copper Contributor
Jun 24, 2022
Hi, Can I know what syntax you have used?