the below code removes commas in cell A1.
How do I need to modify the code so that everything after a comma is deleted?
e.g. from "name,address,age" to "name"
Sheets("Sheet1").Range("A1").Value = _ Application.WorksheetFunction.Substitute(Sheets("Sheet1").Range("A1").Value, ",", "")
Bookmarks