Excel to Text

[jjayon2013]

I currently have an excel document that has mutiple values in multiple cells. I'm trying to create a script by gathering the data from only a few specific cells. I don't know if this is the best way to do this but I have selected the cells with the data I need and put that information in only a few cells to the right. Because I used the = sign to specify the data on the other cells it will not let me copy the 5 cells and only lets me paste the left most cell. I'm trying to gather the specific data on put that in notepad.

For example (my data on the left and what I want it too look like in notepad on the right in bold):

201 999 $999 199 LEVEL $99 99 00 263 PEERL Yes REP 201 201 FRTE 199


Is there a way to do this so I can transfer the specific cells into notepad? The other issue I noticed was if I manually just put the data in each cell and just copy it without the = for forumulas it will put the spaces that my script doesn't like. Is there a way to copy and paste into notepad without those spaces or just deal with removing them line by line?

[FDibbins]

Hi and welcome to the forum

I dont understand how you go from
201 999 $999 199 LEVEL $99 99 00 263 PEERL Yes...to...
REP 201 201 FRTE 199?

what exactly are you trying to do?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.