To fully retain the characters while saving it on a CSV format and to somehow be able to import/re-use the data in the future.
You can follow these steps.
- In Microsoft Excel, open the *.xlsx file.
- Select Menu | Save As.
- Enter any name for your file.
- Under “Save as type,” select Unicode Text.
- Click Save.
- Open your saved file in Microsoft Notepad.
- Replace all tab characters with commas (“,”).
- Select a tab character (select and copy the space between two column headers)
- Open the “Find and Replace” window (Press Ctrl+H) and replace all tab characters with comma .
- Click Save As.
- Name the file, and change the Encoding: to UTF-8.
- Change the file extension from .txt to .csv.
- Click Save.
- Open the .csv file in Excel to view your data.
Step 1: In the top-right corner of the browser window, click the Chrome menu
Step 2: Select Bookmarks > Bookmark Manager.
Step 3: Click the “Organize” menu in the manager
Step 4: Select Export bookmarks.
Chrome will export your bookmarks as an HTML file, which you can then import into another browser.
We all know how we love shortcuts … check out the below shortcuts and cheat sheets to make designing quicker.
So you got a huge document and want to move quickly between pages. Use the Go To navigator in Word 2013. Hit CTRL + G for the below and enter the page number.
Happy Scrolling …