How to quickly add a number number to a cell in Excel before text?

The specific steps are as follows:

The materials that need to be prepared are: computer, excel**.

1. First of all, open the required excel** and enter the page.

2. Then click the cell behind the text to enter the formula: =row(a1)&"、"&a1, press enter to confirm.

3. Then click the lower right corner of the B1 cell to drop down and fill the cell.

For example, you want to prefix all the numbers in column A1 with "ABCD".

First of all, move the cursor to cell B1 and click on cell B1.

In the Function input box in the toolbar, enter ="abcd"&a1”。

Enter and you will see the gorgeous "ABCD1".

Next, take advantage of the commonly used auto-sort drop-down method and drag the b1 row to where you need it. (It's the little black cross in the lower right corner of that cell), release it to finish.

If you want to add a suffix to the end, then change the formula to "=a1&"."abcd"As shown in line C1.

Also press enter, pull down to automatically sort.

If your data is in the first row then you can use this formula, if the data is in column a, then enter =row()& in cell b1"、"&a1 If your data has a header row, and the data starts from the second row, use the following formula=row()-1&"、"&a1 Got it, row() is the return of the current line number.

Let the original text be in column a, and output in column b, the formula for b1: =row(a1)&"、"&a1 in the drop-down.

1. First of all, open Excel** and select the cell that needs to be set to automatically add the word Bi Blind Hungry Mother.

2. Then right-click and click "Format Cells" in the pop-up options.

3. Then select "Custom" in the pop-up repentance dialog box, and set the type to:"ma", click OK.

4. Return to the ** page, enter the number in the set and pure cell, and then "ma" can be displayed in front of the number.

1. For example, the serial number from 1 to 10; So, I'll enter 1 first; Then enter 2 in the cell below

2. We can also use another method, enter 1 first; Place the mouse over the fill handle in the lower right corner of the cell and <>

3. Click and hold Qijian to pull down and pull it to the cut-off cell; At this time, we see that the cells are all displayed as 1; And there is a fill option button on the right side of the last cell. Mouse click this button.

4. In the pop-up options, we select: Fill the serial number.

5. Instantly, the Excel cell number has letters and numbers, so that the following numbers can be added.

Excel cell numbers are composed of numbers and letters, but to be precise, it should be in the excel worksheet, each cell has a unique number called the address, and the method of making the address is letters plus numbers. Letters come first, numbers come last. Such as:

A1, F4, etc.

According to Encyclopedia: Microsoft Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation and charting tools, plus a successful marketing boost.

Make Excel the most popular data processing software for personal computers. With the release of Excel in 1993 as a component of Microsoft Office, Excel began to dominate spreadsheet software on all operating platforms.

1. First of all, open the excel** program, click "Insert" at the top, and click on the chain to open.

2. Select "Symbol" in the drop-down menu and click Open.

3. Select "Other Symbols" in the window and click to open.

4. Select "Shed Ordinary Text" in the dialog box and click to open.

5. Finally, you can select the numeric serial number in the dialog box, click enter, and the problem is solved.

Once the numbers are selected, you can format the cells. Let me show you the detailed steps ().

PC model: HP Shadow Phantom 8Pro, software and version number: WPS

1. Open an excel**, as shown below, and add letters in front of the number.

2. After selecting all the numbers, click the right mouse button and select Format Cells.

3. Click Custom, enter A0 as the type (A is the letter code that is added), and then click OK.

4. In this way, all the numbers are added with letters, as shown in the figure below.

The above is the tutorial of adding letters in front of the numbers in excel, and those who have learned it should try it *

1. Find excel on the desktop, and open the ** that is ready to add text to the unified noise model.

2. For example, in the following example, the letter D needs to be added before the content of column A.

3. A new column needs to be added, column B. Enter the code "="d"&a2" in column b and press enter. It's the same as in the figure below.

4. Then move the mouse to the dot in the lower right corner of the Ascending Plum cell to make the cursor turn into a cross.

5. Then hold down the mouse and pull it down, so that you can add a letter in front of the number in Excel**.

=concatenate("s";a1) formula. First, enter the company in other Henglu rock columns and pull down to get the data starting with s. Then use the value of the selective paste to replace the previous Arabic numerals.

The specific setting method is as follows: 1. Open an excel file on the computer and enter the required values. 2. Enter the formula =concatenate( in another column"s";a1) and press enter, you can see that the newly added data has been implemented s plus Arabic numerals, drop down to fill the formula.

3. At this time, select the generated word and let the handwriting Bimu add numbers, click the right button, and select the copy button. 4. After the data is copied, click the right key in the original cell, and then click Paste Selective. 5. Click the OK button after checking the value in the paste special dialog box that appears.

6. At this time, you can see that the original Alatan Qinbo number has been added with the letter S. Select the columns you don't want and right-click to delete. 7. At this time, you can see that the redundant data columns have been deleted and the effect of adding letters in front of the numbers has been realized. [

Suppose you want to add the letter "x" before the number, here's how.

Method 1. Use the method of formatting cells:

Select the cell or range of cells where the data is located--- right-click --- format the cell --- write in the custom --- type"x"g Common Format --OK.

Note: If it is a number in text form, the custom format will be changed to"x"@；

If they are all integer numbers, the custom format can be changed to"x"0。

As shown in the figure below, column A data:

After customizing the format using the Dig.

Method two. Derive in another cell with a formula:

Assuming the data is written in column A, the guessing data starting from cell A1 is written as a formula in cell B1.

if(a1=""x"&a1)

Drop-down fill formula.

Method three. Derive in another cell with a formula:

Assuming the data is written in column A, the data starting from cell A1 can be written with the letter "x" in cell C1", and then write the formula in cell b1.

if(a1=""c$1&a1)

Drop-down fill formula.

If it is only for the display, then you can select the area where the data is located, right-click, "Set Cell Format", "Number", "Custom", enter the type A, and add the letter A before the number. For details, please refer to the keyhole example shown in the attached figure [o].

Select the cell range - right-click - set cell format - number - custom - type:

0 – OK.

Upstairs says: Enter single-width quotation marks and plus signs before the number (e.g. .'+125) is fine, but the numbers are in text format, which is not convenient to participate in the calculation.

Enter a single quotation mark in English first, and then type in what you want.

That is, to convert your numbers into text format.

It's best to take a screenshot of the table, otherwise I don't know what the specific situation is.