Look Who it Was Random video

How to Export data from Excel to pipe delimited text file - Bangla Excel Tutorial

3,871 views · Published 13 November 2015 · 2:14 · Indexed 31 October 2026

Channel: Tech Help Bangla · 2015 · Science & Technology

Watch on YouTube

This tutorial is going to show you how to export Excel data to a pipe delimited text file

In this tutorial you are going to learn how to export data from excel to pipe delimited text file.
 
Step # 1 -- Opening Region and Language Settings

Close Excel if you have the program open. Click "Start" and then click "Control Panel". In the window that appears you need to click on the "Region and Language" option. At the bottom of this new window click on the "Additional settings..." button.
 
Step # 2 -- Changing the Default List Separator

This will open the "Customize Format" window. Locate the "List separator" box and replace the comma with the pipe symbol. Click "OK" and then "OK" again in the previous window. Now you need to open the Excel file that you want to export.
 
Step # 3 -- Saving the File

Once the file has loaded click the "File" option in the main menu and then click on the "Save As" option. In the window that opens click on the drop down box next to "Save as type", and from this list you need to select the option "CSV (Comma delimited)". Click on the "Save" button, and in the dialog box that appears click "OK".  
 
Step # 4 -- Opening the File with Notepad

This is how to export data from excel to pipe delimited text file, and to view the file in Notepad go to where it is located, right click on it, navigate to "Open with" and click "Notepad". As you can see all the bits of data from the file are separated with the pipe delimiter.

#excel #excel_tutorial

For more interesting updates Please subscribe My Channel
https://goo.gl/LxvJqw

🌐 Facebook : https://goo.gl/YcHTeu

🌐 Twitter : https://goo.gl/q8mxDd

🌐 Google+ : https://goo.gl/uzfDg4

🌐 Instagram : https://goo.gl/RB02Qx

🔊 LIKE ➡ SHARE ➡ SUBSCRIBE

Watch More...
YouTube Tips And Tricks Playlist :   https://goo.gl/hPCs7W 

How to Make Money Online Playlist : https://goo.gl/myvPRH

Windows 10 Tips And Tricks Playlist : https://goo.gl/9ZbhXe

Common Tutorials Playlist :  https://goo.gl/L4W68f

Mobile Tips And Tricks Playlist :  https://goo.gl/cUnFML 

Photoshop Tutorial Playlist :  https://goo.gl/wtP45V

Facebook Tips And Tricks Playlist :  https://goo.gl/HALw6W

My Channel is The best & ultimate technology platform for Bangladeshi tech peoples in Bangla language. You can get lots of technology news, android tips, review, photo editing, unboxing, computer tricks & tips, mobile tricks and more.

#Tech_Help_Bangla

note: all the image picture shown in the video belongs to the respected owner and not me. i am not the owner of any pictures showed in the video.

DISCLAIMER: This Channel Does Not Promoted Any Illegal Content, All Content Provided By This Channel Is Meant For EDUCATIONAL purposes Only.

More from this channel