Eric's Blog

1、 Extract 1.=IFERROR (MID (A1, FIND ("-", A1, FIND ("-", A1)+1)+1, LEN (A1) - FIND ("-", A1, FIND ("-", A1)+1), "") The first line=IFERROR (MID (A2, FIND ("-", A2, FIND ("-"

-Read the full text-

1. Take data in A1 as an example Method 1: Province=LEFT (A1, MIN (FIND ({"Province", "City", "District"}, A1&"Province and City")) City=SUBSTITUTE (LEFT (A1, MIN (FIND ({"City", "District", "County"}, A1&"City, District and County"))

-Read the full text-

A problem with this file was detected. Some tables can be opened, and some cannot. When other tables are opened, their two versions are normally used. The problem in office2013 and office2010 has been studied. It is unclear. The solution is to modify the registry. Change the registry file by yourself, and then double-click to register. (Run as administrator) Registry modification: office2010Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER So

-Read the full text-

As an example, a page break is automatically inserted every 1 line. 1. First call out the development tool in Excel, click "File" -- "Options" -- "Development tool", and then click "OK". 2. Next click "Development tool" to open the VBA editor. 3. Then in the editor, write a program that automatically breaks pages every 5 lines, and then click "Run". The editor writes the program of this example for the convenience of netizens to copy. The program is as follows: Sub paging () For i=6 To 20 Step 1 '[Step 1] means that one line is executed

-Read the full text-

First, install Microsoft Access Database Engine 2010 Redistributable (or AccessDatabaseEngine_X64) http://www.microsoft.com/downloads/zh-cn/details.aspx?FamilyID=C06B8369 -60DD-4B64-A44B-84B371EDE16D

-Read the full text-

Troubleshooting: "Start Run Enter regedit, then open the registry" HKEY_CURRENT_USER -- Software -- Microsoft -- Office -- 14.0 -- Excel -- Security ", rename EnableDEP to:" ExtensionHardening ", then right-click" ExtensionHardening "- modify [M] - set the value to 0 and save

-Read the full text-

Excel documents cannot be opened directly. To solve this problem, click File - Open - Select. The operation steps are as follows: Tools, Options, and General tabs. Remove the check before Ignore Other Applications [This situation is often caused by the version or other reasons] IgnoreRemoteRequests. Try to execute the following code Application IgnoreRe

-Read the full text-