Dear Excel Geek,
I have a program that exports a tab-separated values into the clipboard. When I paste directly into excel (for example at A1), the values are automatically formatted into a table with 7 columns (A-G) and 6 rows
This is okay but I do not need all the headers and all of the columns and rows.
Is there a way to paste only a specifc cell from what is copied from the clipboard, in this case only cell D6?
I nomally select and copy again cell D6 and paste it to where I need it. If there is a way to eliminate the extra copy and paste step, that would be really useful.
I looked into the text import wizard but I dont think this is the feature I want.