Excel controls the number of lines in such a block using the line-feed character, "CHAR(10)." Visual Basic for Applications, also called VBA, can count line numbers by counting the number of line ...

To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).

Open the Excel 2010 files that holds your phone numbers. Click on the cell that you want to change into a series of numbers spread out over several columns, or click on the letter above the column ...