Excel with cells that auto-delete content

[danieljoachim]

I want to use a standardized copy-paste function that gives me too much information ("copy to clipboard" in meetings in Outlook 2013). That is, it gives me three columns with information, and I only want to keep the information in the first one.

However, I want to make a template document, that can be used by external users, that will only keep the information in the first column. This should happen without the user having to mark the second and third column her-/himself and delete it manually.

- So can I make a formula/macro so that all content added to column 2 and 3 will be auto-deleted, while the content in column remains?

Thank you!

[AstToTheRegionalMGR]

I don't think there would be a quicker way than just Deleting the second and third columns.

But if that isn't really an option, I think your best bet would to have a "Paste" sheet and a "Final" Sheet. On the Paste sheet, just have them paste in column A, so it will fill into Columns A, B, and C. Then in the "Final" Sheet, in Column A, just input into Cell A2 (Assuming the top Row is a Header) ='Paste'!A1 Then, if you click back on Cell A2, hover over the bottom right corner of the cell until your cursor turns into a thin black plus sign, as opposed to the thick with plus sign that it normally looks like, click, hold, and drag as far down as you'd like to go. This "Final" sheet will now equal what is in Column A of your "Paste" sheet.

Hope that helps!