How to add prefix or suffix to a range of cells in Excel

0
3

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

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

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.

READ :  Fix Not Implemented error in Outlook on Windows

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

Hit Enter when done in addition to it volition add together the prefix to every entry inward the intended column.

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

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)

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

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"

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

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.

READ :  Privacy Options in Microsoft Office Suite

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

Hit Enter when done in addition to it volition add together the suffix to every entry inward the intended column.

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

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")

If yous postulate to add together a sure as shooting prefix or suffix to a listing across a column inward Microsoft Excel How to add together prefix or suffix to a make of cells inward Excel

Use spaces piece adding the prefix in addition to suffix accordingly.

Hope this helps!


Source: https://www.thewindowsclub.com/

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.