How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches

How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches. In Excel, sometimes it is necessary to add prefixes to a large amount of data to distinguish or mark them. At this time, how to quickly add prefixes in batches becomes a problem. This article will introduce several methods to quickly add prefixes in Excel, allowing you to easily meet your data processing needs. Whether you are working or studying, these methods can help you improve your work efficiency and make data processing more convenient and faster. Next, let’s take a look at the specific steps.

　How to quickly add a prefix in Excel?

1. Cell format method

1. Select the cell range and press Ctrl 1 at the same time to set the cell format. (Or right-click the mouse and select Format Cells)

2. Click [Customize], enter "Finance Department-@" in the [Type] option, and finally click [OK] to complete!

2. Plug-in method

1. Download and install the Excel plug-in Square Grid.

2. Click the [Square Grid] option.

3. Select the cell range, select [Insert Text], click [Insert Text to the Beginning], then enter the prefix information in the pop-up dialog box, and click [OK] to complete.

3. Intelligent filling method

Note: This method is suitable for higher versions of Excel and WPS. Lower versions of Excel do not have this function!

1. Insert an auxiliary column.

2. Enter "Finance Department-Han Ying" in the auxiliary column cell, then click the mouse on the next cell and press [Ctrl E] at the same time to quickly fill it.

The above is the detailed content of How to quickly add a prefix in Excel? How to add prefixes to Excel tables in batches. For more information, please follow other related articles on the PHP Chinese website!