For those who want to add a prefix or suffix to a checklist throughout a column in Microsoft Excel or Excel on-line, this text shall be useful. For example, if we’re introduced with a lengthy checklist of names and want to add a title, say physician, earlier than it, how will we do it simply?
Add Prefix or Suffix to all cells in Excel
How to add a prefix to a number of (or all) entries throughout a column
We are able to use two capabilities to add a prefix to a number of (or all) entries throughout a column. The primary one is utilizing the & operator, and the second is utilizing the CONCATENATE perform.
The formulation for the & operator is as follows:
=” “&
The place
is the prefix to be added and is the placement of the primary cell in the column to which to add the prefix.Eg. We’re creating the checklist in column C. If the primary cell in the column for which we’d like to add the prefix is A3, and the prefix is TWC, the formulation could be:
="TWC "&A3
We might have to place this formulation in cell C3 because it wants to be in the identical row as the primary entry, which wants the prefix.
Then click on wherever exterior the cell. Now click on on the cell once more, and it’ll spotlight the choice to choose extra cells in the identical column. Pull the checklist down corresponding to the entries for which you want the suffix.
Hit Enter when accomplished, and it’ll add the prefix to each entry in the meant column.
Alternatively, you could possibly use the CONCATENATE perform for including the prefix:
=CONCATENATE("",)
Within the instance talked about above, the perform would turn into:
=CONCATENATE("TWC ",A3)
How to add a suffix to a number of (or all) entries throughout a column
We are able to use two capabilities to add a suffix to a number of (or all) entries throughout a column. The primary one is utilizing the & operator, and the second is utilizing the CONCATENATE perform.
The process for including a suffix utilizing the & operator is as follows:
=&""
The place is the suffix to be added and is the placement of the primary cell in the column to which to intend to add the suffix.
Eg. We’re creating the checklist in column C. If the primary cell in the column for which we’d like to add the suffix is A3, and the suffix is pending, the formulation could be:
=A3&" pending"
We might have to place this formulation in cell C3 because it wants to be in the identical row as the primary entry, which wants the suffix.
Click on wherever exterior the cell after which again on the cell. Pull the formulation down throughout the column until you want to add the suffix for the cells in the meant column.
Hit Enter when accomplished and it’ll add the suffix to each entry in the meant column.
Alternatively, you could possibly use the CONCATENATE perform for including the suffix:
=CONCATENATE(,"")
Within the instance talked about above, the perform would turn into:
=CONCATENATE(A3," pending")
Use areas whereas including the prefix and suffix accordingly.
I hope this helps!
Learn: Repair Unable to insert Columns in Excel.
