Import the text from the Sloan text file into a new workbook.

Use Notepad (or another text editor) to open the text file named Sloan.txt from the Chapter 7 folder to examine the data, and then close the file and Notepad.
2. Import the text from the Sloan text file into a new workbook. Name the work- book Johnson-Sloan.xlsx and save it in the Chapter 7 folder. Rename Sheet1 as Imported Data.
3. Convert the information in the worksheet into columns, if necessary.
4. Sort the data by category and then by product number in ascending order.
5. Use the CONCATENATE function to add the appropriate prefix and a dash to each category in a new column titled CategoryPrefix using the following list. For example, the Analyzer category would begin with 600, followed by a dash and the category name (600-Analyzer). (Hint: Try placing these values in your spreadsheet in a column named Prefix using a VLOOKUP function.)

Last Completed Projects