If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel or Excel online, in addition to then this article volition travel helpful. For instance, if nosotros are presented alongside a long listing of names in addition to nosotros postulate to add together a title, nation MD earlier it, how produce nosotros produce it easily?
Add prefix or suffix to all cells inward Excel
How to add together a prefix to multiple (or all) entries across a column
We could occupation 2 functions to add together a prefix to multiple (or all) entries across a column. The start i is using the & operator, in addition to the minute is using the CONCATENATE function.
The formula for the & operator is equally follows:
=”<prefix> “&<cell divulge of start cell>
Where <prefix> is the prefix to travel added in addition to <cell divulge of start cell> is the place of the start jail mobile telephone inward the column to which to recollect to add together the prefix.
Eg. We are creating the listing inward column C. If the start jail mobile telephone inward the column for which nosotros postulate to add together the prefix is A3, in addition to the prefix is TWC, the formula would be:
="TWC "&A3
We would accept to house this formula inward jail mobile telephone C3 since it needs to travel inward the same row equally the start entry which needs the prefix.
Then click anywhere exterior the cell. Now click on the jail mobile telephone again, in addition to it volition highlight the selection to direct to a greater extent than cells inward the same column. Pull the listing downward corresponding to the entries for which yous postulate the suffix.
Hit Enter when done in addition to it volition add together the prefix to every entry inward the intended column.
Alternatively, yous could occupation the CONCATENATE component division for adding the prefix:
=CONCATENATE("<prefix>",<cell divulge of start cell>) In the representative mentioned above, the component division would become:
=CONCATENATE("TWC ",A3) 
How to add together a suffix to multiple (or all) entries across a column
We could occupation 2 functions to add together a suffix to multiple (or all) entries across a column. The start i is using the & operator, in addition to the minute is using the CONCATENATE function.
The physical care for for adding a suffix using the & operator is equally follows:
=<cell divulge of start cell>&"<suffix>"
Where <suffix> is the suffix to travel added in addition to <cell divulge of start cell> is the place of the start jail mobile telephone inward the column to which to recollect to add together the suffix.
Eg. We are creating the listing inward column C. If the start jail mobile telephone inward the column for which nosotros postulate to add together the suffix is A3, in addition to the suffix is pending, the formula would be:
=A3&" pending"
We would accept to house this formula inward jail mobile telephone C3 since it needs to travel inward the same row equally the start entry which needs the suffix.
Click anywhere exterior the jail mobile telephone in addition to and then dorsum on the cell. Pull the formula downward across the column till where yous postulate to add together the suffix for the cells inward the intended column.
Hit Enter when done in addition to it volition add together the suffix to every entry inward the intended column.
Alternatively, yous could occupation the CONCATENATE component division for adding the suffix:
=CONCATENATE(<cell divulge of start cell>,"<suffix>")
In the representative mentioned above, the component division would become:
=CONCATENATE(A3," pending")
Use spaces piece adding the prefix in addition to suffix accordingly.
Hope this helps!
Source: https://www.thewindowsclub.com/
comment 0 Comments
more_vert