Excel Combine Two Columns Of Text Into One Without Formula Excel Macro Tips – How To Remove Personal Information From Excel Using Some Simple VBA

You are searching about Excel Combine Two Columns Of Text Into One Without Formula, today we will share with you article about Excel Combine Two Columns Of Text Into One Without Formula was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel Combine Two Columns Of Text Into One Without Formula is useful to you.

Excel Macro Tips – How To Remove Personal Information From Excel Using Some Simple VBA

In every Microsoft Excel workbook, there will be some personal information stored inside by default, which will be hidden in the workbook or within the document properties (this is called meta data). The different types of information stored may include:

  • your name

  • Your initials

  • Your company or organization name

  • Your computer name

  • The name of the network server or hard disk where you saved the workbook

  • Other file properties and summary information

  • Invisible parts of embedded OLE objects

  • Document revision

  • Hidden text or cells

  • Personalized views

  • Comments

If you plan to share your workbook electronically with other people, it’s a good idea to remove any personal information from it. I always remove my personal information from my workbooks, especially when making my Excel templates and examples available for public download. Here’s a quick and easy way to write an Excel macro to remove this type of information from your Excel workbook. It’s really easy, and once you get used to it, it can become part of your normal routine for saving your Excel workbooks.

  • Open your Excel workbook that you want to remove your personal information from

  • Press ALT+F11 as a shortcut to open the Developer tab or you can alternatively select Developer tab – Visual Basic.

  • Click Insert Module

  • Type the code below in the module

Sub Remove_Information()

ActiveWorkbook.RemovePersonalInformation = true

end sub

You can now easily run the code by selecting the following

  • Click on the Developer tab

  • Select Macro

  • Select Remove_Information (this is the name we gave the macro in the first line of code.

  • Press OK

  • The next time your workbook is opened, your personal information will disappear.

Alternatively you can run the code in the immediate window which is really useful, as it can be used as a sort of sandbox to test the live results of your macro and see the results. If you need to enable the prompt window if it is not visible, press ALT + F11, then press . CTRL+G to open an immediate window and place the cursor on it.

Then all you have to do is type the name of the macro in the window where the cursor is flashing. In this example we will type Remove_Information Then hit return and the macro runs.

Video about Excel Combine Two Columns Of Text Into One Without Formula

You can see more content about Excel Combine Two Columns Of Text Into One Without Formula on our youtube channel: Click Here

Question about Excel Combine Two Columns Of Text Into One Without Formula

If you have any questions about Excel Combine Two Columns Of Text Into One Without Formula, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Excel Combine Two Columns Of Text Into One Without Formula was compiled by me and my team from many sources. If you find the article Excel Combine Two Columns Of Text Into One Without Formula helpful to you, please support the team Like or Share!

Rate Articles Excel Combine Two Columns Of Text Into One Without Formula

Rate: 4-5 stars
Ratings: 9419
Views: 26503829

Search keywords Excel Combine Two Columns Of Text Into One Without Formula

Excel Combine Two Columns Of Text Into One Without Formula
way Excel Combine Two Columns Of Text Into One Without Formula
tutorial Excel Combine Two Columns Of Text Into One Without Formula
Excel Combine Two Columns Of Text Into One Without Formula free
#Excel #Macro #Tips #Remove #Personal #Information #Excel #Simple #VBA

Source: https://ezinearticles.com/?Excel-Macro-Tips—How-To-Remove-Personal-Information-From-Excel-Using-Some-Simple-VBA&id=9527838