Just copy it from the email, open your Web browser, and paste the link into the address field (technically called the “URL field” for Uniform Resource Locator). The word-wrap function is found in different places within different email programs.

1. Eighth Note Copy Paste

. Open Excel to a blank worksheet. Type anything into A1; e.g.;dkhgf. With A1 selected, choose Data, Text to Columns.

Eighth Note Copy Paste

Select Delimited from the first set of option then Next. Turn off all delimiters and click Finish. Erase the random cell contents from A1. Go to Notepad and tap Cltr+A (aka Select All) then Ctrl+C (aka Copy). Back at Excel, right-click the destination cell and choose Paste, Keep Text only icon. Excel 'remembers' previous Text to Columns settings and attempts to use them when you paste copied text into a worksheet. If you have any tabs (ASCII 009) in the original text, Excel will not display them but they will interfere with data manipulation.

Addendum: if you have played around with line feeds in the original text, they will break to a new line. Not much can be done about that. Addendum²: this reply largely duplicates the one from above; it just got posted 1½ minutes later. I'm leaving it here instead of removing it as I believe there are a couple of salient points that add to the discussion. An example of the data in notepad would help because I can copy from notepad to excel and it always copies into one cell so maybe your data is in a different format.

Having said that, you can use the import feature of Excel as follows:. Select the cell on the worksheet where you want the data to start. Select Data ribbon. In the 'Get external data' block at the left select 'From text'. In the dialog that opens browse to and open the required text document.

In new dialog Select Fixed width (if not already selected) and click Next. In the data preview remove the data separator lines. (Either double click on the line or click on the line and drag off the pane). You can also add delimiters by simply clicking at any position plus you can click on any separator and drag to new location. If you only want some of the data from your text file then you could copy required data to a new notepad file and then do the above.

Alternatively save the notepad file to a new name and edit out the data not required. Hope this helps. Regards, OssieMac.