How To Add Comma In Excel?

Select the cell or range where you want the comma

Type the comma directly from the keyboard

Use `=A1&”,”&B1` to add a comma between cell values

Use `=TEXTJOIN(“,”,TRUE,A1:A10)` to join values with commas

Use `=CONCAT(A1,”,”,B1)` to combine text with a comma

Use Find and Replace to add commas to existing text

Use Custom Number Format if you want commas in numbers

Use `Ctrl + H` to open Find and Replace

Enter the text to change in Find what

Enter the comma in Replace with

Click Replace All

Suggested for You

Trending Today