How to Add Commas to Every Line on Excel 2007

Save

Using Microsoft Excel functions allows you to format text in a variety ways. For example, you might have a set of data to which you need to add commas. You can do this by taking advantage of the "&" function. By using a temporary column in your spreadsheet, you can add commas to every line of text, then replace you original data with the newly formatted data. If you are familiar with Microsoft Excel functions, this process will only take a few minutes.

  • Locate a column that will be used temporarily to add the commas.

  • Double click the first cell in this column and type the formula =[DataCell1]&"," replacing [DataCell1] with the column that stores your data. For example, =D1&",".

  • Copy this cell.

  • Select the entire column and paste the cell to fill the entire column with this formula. This will fill each cell with the source data and the added comma.

  • Copy this column again.

  • Select the original column with your data and click on the arrow below the "Paste" button on the "Clipboard" menu. Choose "Paste Values."

  • Delete the temporary column you used to add the commas.

References

  • Photo Credit Jupiterimages/Photos.com/Getty Images
Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!