I use Notepadd++ as a great way to copy text into Excel VBA
![](https://community.notepad-plus-plus.org/assets/uploads/files/1626713653539-odd-conversion-from-notepad.png)
![](https://bvisual.net/wp-content/uploads/2023/08/RunMacroOnce-1024x879.jpg)
Using Notepad++ to Edit Visio ShapeSheet formulas - bVisual
![](https://media.geeksforgeeks.org/wp-content/uploads/20211016075833/rT002.png)
How to Read Data From Text File in Excel VBA - GeeksforGeeks
![](https://community.notepad-plus-plus.org/assets/uploads/files/1648837145290-debug-from-notepadpp.png)
I use Notepadd++ as a great way to copy text into Excel VBA. However I notice that the underscore character gets converted to strange character
![](https://i.ytimg.com/vi/xHr7WXjK4dc/hqdefault.jpg?sqp=-oaymwEmCOADEOgC8quKqQMa8AEB-AH-CYAC0AWKAgwIABABGEcgZShlMA8=&rs=AOn4CLC7zzkN7kqdy3CCiMeEqojqgLjaQw)
how to extract notepad data in excel
![](https://thomas.vanhoutte.be/miniblog/wp-content/uploads/notepadplusplus.png)
Add/Insert text before each line in Notepad++
![](https://community.notepad-plus-plus.org/assets/uploads/files/1626713653539-odd-conversion-from-notepad.png)
I use Notepadd++ as a great way to copy text into Excel VBA. However I notice that the underscore character gets converted to strange character
![](https://www.exceltip.com/wp-content/uploads/2015/07/img119.png)
Remove Extra Commas In Notepad from Microsoft Excel
![](https://i.stack.imgur.com/7CH04.png)
string - Extra quotes after every quotes when I copy and paste to notepad from excel - Stack Overflow
![](http://www.dailydoseofexcel.com/blogpix/npformeditor5.gif)
Formula Editor in Notepad++ – Daily Dose of Excel
![](https://www.cathrinewilhelmsen.net/images/notepad/CathrineWilhelmsenNotepadPlusPlusColumnEditing01.png)
Notepad++ Column Editing
![](https://community.notepad-plus-plus.org/assets/uploads/files/1629892950198-dd068f99-b06d-4b85-8776-2fccd99d8269-image.png)
New release: Notepad++ v8.1.4
![](https://www.excel-easy.com/vba/examples/images/read-data-from-text-file/read-data-from-text-file-example.png)
Read Data from a Text File using Excel VBA (In Easy Steps)