Forum Discussion
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 ...
also if i have blank in my cell how to change the syntax
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.
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.
dscheikey hi I used your syntax to get the answer .but in one cell in my 1st column I have 54 values, I have used formula for 2nd column to count the skills ..in 2nd column it has 51 skills , but I got answer as 54. Which is taking data from 1st column.I want count of valued from 2nd column as 51.can you let me know.
