A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.
EC Research Institute Co., Ltd.
About This Product
■Applications/Features
- Search and replace text in sheets, text boxes, headers/footers, and graphs. Supports grouping.
- Supports folder processing. Search and replace from all sheets of all applicable files.
- Supports format maintenance and replacement. Formatting other than replacement characters is maintained and will not be corrupted.
- It is possible to register multiple character strings (up to 100 in the initial state) and process them at once.
- Now you can search and replace "accurately," "quickly," and "easily" what used to be checked visually and corrected manually.
-Can also be used as a batch conversion macro.
■Processing overview
This macro searches for the specified string and replaces it as directed.
■Supports batch processing of multiple strings
- You can register a large number of character strings (100 sets in the initial state) that you want to search and replace, and process them all at once.
-Very effective for numerous investigations and conversion tasks.
・As many as 100 sets can be registered, so you can easily add possible character strings. If you can't find it, that will give you peace of mind.
- Parameters such as search and replacement strings are written on a sheet, so they can be easily saved and reused. Also, since it can be added to and modified, it can be used repeatedly, and efficiency and reliability will improve with repeated use. The parameters themselves are the know-how.
- Can also be used as a single set of regular search and replace macros. You can use it freely.
■There are many targets that can be searched and replaced, and extensive investigation and conversion is possible. Compatible with the following:
- You can also search and replace character strings written in shapes and figures such as text boxes. Moreover, it is compatible even if it is grouped.
- Graph titles, axis titles, data labels, etc. can also be searched and replaced. (If linked to a data cell, search and replace with the cell)
-Of course, formulas and values written in cells are also supported.
・Comments are also possible. (Depending on the version of EXCEL, it may be called a memo.)
- You can also search and replace headers and footers that are easy to miss.
- You can search and replace sheet names that are easy to miss among many books.
・File name Can be searched and replaced using folder processing.
・Folder name Can be searched and replaced using folder processing.
-
Product
A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.
-
Handling Company
EC Research Institute Co., Ltd.
-
Categories
1 Models of A macro that searches for a specified string and replaces it based on instructions. Can also search text boxes and folders. ``Effective Cells'' series bulk search and replace macros for business use.
| Product Image | Part Number | Price (excluding tax) |
|---|---|---|
|
|
Bulk search and replace macro (for business use) |
Available upon quote |
Customers who viewed this product also viewed
Other products of EC Research Institute Co., Ltd.
View more products of EC Research Institute Co., Ltd.
