How to add space after comma in excel
This tutorial explains how to use a combination of the TRIM and the SUBSTITUTE function to add space after comma in a text string in Excel. How to add space after comma in a string in Excel?Supposing you have received a list containing names with no space after the comma as the below screenshot shown, you can apply the following formula to add space after the comma easily. Generic formula =TRIM(SUBSTITUTE(A1,",",", ")) Arguments A1: Represents the cell containing the text string you will add a space after the comma. How to use this formula? 1. Select a blank cell to output the result. Here I select cell D3. 2. Enter the below formula into it and press the Enter key. And then drag its Fill Handle down to apply the formula to other cells. =TRIM(SUBSTITUTE(B3,",",", ")) Then you can see a space is added after each comma in specific cells as the above screenshot shown. How this formula works? =TRIM(SUBSTITUTE(B3,",",", "))
Related functionsExcel TRIM function Excel SUBSTITUTE function Related formulasAdd comma after first word in a cell in Excel Separate numbers from units of measurement Split
text and numbers in a cell in Excel Split Text String At Specific Character In A Cell In Excel Add A Specific Character Before Each Word In A Cell The Best Office Productivity ToolsKutools for Excel - Helps You To Stand Out From CrowdWould you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 80% time for you.
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
Comments (0) No ratings yet. Be the first to rate! How do you put a space after a comma?Commas separate parts of a sentence into logical elements. Commas have no meaning, but they help us to see the structure and therefore the meaning of the sentence. Put a space after a comma. Do not put a space before a comma.
How do I separate text after a comma in Excel?Try it!. Select the cell or column that contains the text you want to split.. Select Data > Text to Columns.. In the Convert Text to Columns Wizard, select Delimited > Next.. Select the Delimiters for your data. ... . Select Next.. Select the Destination in your worksheet which is where you want the split data to appear.. How do you put data after a comma in Excel?(1) If you want to extract text before or after comma, you can change " " to ",". (2) If you want to extract the text after space only, use this formula =MID(A1,FIND(" ",A1)+1,256). (3) This method extracts text by the first space in specified cells.
|