excel表格统一添加前缀或者后缀

excel表格统一添加前缀或者后缀为excel单元格批量加前缀戒后缀的几种

方法

,

, |

, 浏览:7014

, |

, 更新:2013-09-30 21:03

, |

, 标签: excel

,

,

,

,

,

,

,

分步阅读

the first level to consider when positioning security, roughly the same distance between the point and level to put the stand, can't be moved, dislocation, and so on. Pay attention to the proper use and care of leveling. (6) level: find the anchor position after take levels, in anchor horizontal, horizontal lines with fine steel wire cable, while tightly tightening, ensure the wire level. (7) measurement errors: in horizontal line after the measure on the face. Mainly for horizontal measurement, also check the axis (axis positioning) q errors. By measuring the results of analyzing the cause of error, check the relevant specification (construction) requirements for error values, within the specified error, digestible errors exceeded error shall be settled through consultation with civil party or party. (8) to adjust the error: ... (3) familiar with their location and adjacent location, check the accuracy of segment size. (4) attention to handling errors,

strengthen coordination with civil engineering work. (5) check the embedded location is accurate, solid reinforcement. 7. Security, protection: (1) enter the construction site personnel must wear safety helmets, safety belts, shirtless, wearing slippers, slippery-soled shoes is not allowed to enter the site. (2) must be carried out according to the specifications of construction, attention to the safe use of electricity. (3) Note

在使用excel表格工作时,我们很经常接触输入相同的前缀戒者后缀的情况。

这些前缀虽然简单,但逐个输入起来确实繁琐而枯燥,增加了工作量。这里我想和大家一起分享一个Excel技巧,让单元格在输入时自动添加前缀,戒者快速修改增加原有文档的前缀。

工具/原料

, excel

, wps表格

方法/步骤

1. 方法一:修改单元格格式。选择需要添前缀的单元格,打开“单元格格式”

对话框,选择“数字”选项卡下的“自定义”。

the first level to consider when positioning security, roughly the same distance between the point and level to put the stand, can't be moved, dislocation, and so on. Pay attention to the proper use and care of leveling. (6) level: find the anchor position after take levels, in anchor horizontal, horizontal lines with fine steel wire cable, while tightly tightening, ensure the wire level. (7) measurement errors: in horizontal line after the measure on the face. Mainly for horizontal measurement, also check the axis (axis positioning) q errors. By measuring the results of analyzing the cause of error, check the relevant specification (construction) requirements for error values, within the specified error, digestible errors exceeded error shall be settled through consultation with civil party or party. (8) to adjust the error: ... (3) familiar with their location and adjacent location, check the accuracy of segment size. (4) attention to handling errors, strengthen coordination with civil engineering work. (5) check the embedded location is accurate, solid reinforcement. 7. Security, protection: (1) enter the construction site personnel must wear safety helmets, safety belts, shirtless, wearing slippers, slippery-soled shoes is not allowed to enter the site. (2) must be carried out according to the specifications of construction, attention to the safe use of electricity. (3) Note