How to automatically add a prefix to the contents of an Excel table

First, if you want to add a fixed content to the contents of a column of cells,

Method One
In the original cell implementation, in two cases

If the content of the original cell is a numeric content, add a prefix such as "ABC" before the original number
Select these cells----right-click----Format Cells---Custom---type write "ABC" g/Universal format---OK

If the contents of the original cell are text content, add the prefix "ABC" before the original content.
Select these cells----right-click----Format Cells---Custom---type write "ABC" @---OK

Method Two
Use the formula to realize
Assuming that the data is written in column A, you can write the formula in cell B1
=if (a1= "", "", "ABC" &A1)
Drop-down Fill formula
The formula means that if cell A1 is empty, a null value is returned, otherwise the "ABC" is added before the contents of the A1 cell

Second, if you want to add a fixed content to a column of cell content, then

Method One
In the original cell implementation, in two cases

If the contents of the original cell are numeric, add a prefix such as "ABC" after the original number
Select these cells----right-click----Format Cells---Custom---type write g/universal format "ABC"---OK

If the contents of the original cell are text content, add a prefix like "ABC" after the original content
Select these cells----right-click----Format Cells---Custom---type write @ "ABC"---OK

Method Two
Use the formula to realize
Assuming that the data is written in column A, you can write the formula in cell B1
=if (a1= "", "",a1& "ABC")
Drop-down Fill formula
The formula means that if cell A1 is empty, a null value is returned, otherwise the contents of cell A1 are added "ABC"

The assumption is to add a fixed content "ABC" to the contents of a column before adding "EFG" at the back, then

Method One
In the original cell implementation, in two cases

If the original content is a digital content, the
Select these cells----right-click----Format Cells---Custom---type write "ABC" g/Universal format "EFG"---OK

If the contents of the original cell are text content, the
Select these cells----right-click----Format Cells---Custom---type write "ABC" @ "EFG"---OK

Method Two
Use the formula to realize
Assuming that the data is written in column A, you can write the formula in cell B1
=if (a1= "", "", "ABC" &A1& "EFG")
Drop-down Fill formula
The formula means that if cell A1 is empty, a null value is returned, otherwise "ABC" is added to the contents of the A1 cell, followed by "EFG"

How to automatically add a prefix to the contents of an Excel table