1. Select the cells that you will add space before each number, and click Kutools > Text > Add Text. See screenshot: 2. In the opening Add Text dialog box, please (see screenshot above): (1) Type a space into the Text box; (2) Check the Only add to option and select 1st character is number from the below drop down list; 3. Click the Ok button.How do you reverse data in Excel?
Step 1: Select the row in which you will flip the data. Step 2: Click the Kutools > Range Converter > Flip Horizontal Range, see screenshot: Then you will see all the data order is reversed in the selected rows. Click Flip Horizontal Range to know more about this feature.How can I convert access to excel?
Assume there is a table as in below format in an Excel sheet. To convert this Excel to Access database, create a new MDB file. Open the MDB file & Choose “External Data” from Menu. Choose “Excel” from the list of sources (Access, Excel, Text, XML etc) Import Tab.How do I show recent files in Excel?
Choose File→Options→Advanced or press Alt+FTA to open the Advanced tab of the Excel Options dialog box. Type a new entry (between 1 and 50) in the Show This Number of Recent Documents text box located in the Display section or use the spinner buttons to increase or decrease this number. Click OK or press Enter to close the Excel Options dialog box.