How do I add a prefix in Google Sheets?

When you create a numbered list in Google Docs, you might want something different at the start of each list item. You can customize the list to use a prefix before the number or suffix after it, here’s how.

You might be making a list of instructions and want the word “Step” in front of each item. Or maybe you have a list of project duties and want “Task” at the start of each. Whatever you want to use, it’s easy to set up.

Create the Numbered List

To start, you’ll create the numbered list. You can do this at the start of typing your list items or after your list is complete.

RELATED: How to Edit, Restart, or Continue a Numbered List in Google Docs

Either use the toolbar and select the Numbered List icon or go to Format > Bullets & Numbering > Numbered List. Then choose the style you want to use whether numbers or letters with periods or parentheses.

Add a Prefix or Suffix to a List

To add a prefix or suffix, select the numbers or letters to highlight them all. You can do this by clicking any one of them in the list. If you select the list, a single list item, or an individual number in the list instead, the feature will be grayed out when you attempt to use it. The exception is if you use a multilevel list.

Click Format > Bullets & Numbering from the menu. Move to List Options and select “Edit Prefix and Suffix” from the pop-out menu.

When the Prefix and Suffix window opens, add one or the other, or both, in the Prefix and Suffix boxes. Check the box for Apply to Entire List and click “OK.”

As an example, we’ll use “Step” as the prefix and a greater than symbol (>) instead of a period as the suffix. You can add spaces after the prefix and before the suffix for formatting if you like.

Then, view the result of your adjusted numbered list.

Remove a Prefix or Suffix

If you decide later to remove a prefix, suffix, or both, it takes only a couple of clicks. Simply select the number or letter with the prefix or suffix to highlight all. Then, choose a different numbered list type. This replaces the current format.

Not every list you create is as easy as one, two, three. So the next time you want to customize a list in Google Docs, check out the prefix and suffix feature to make your list exactly as you need it.

Adding prefix or suffix to a set of cell values in Excel is a very-consuming process when we do it manually, however you can complete such a task very easily just by using the simple formula. This article will help you understand how you can add prefix and suffix to cell values.

How to Add Prefix into Cell Values?

Let see a simple process to add prefix into cell values.

Step 1:

Let us consider we have an excel sheet where it contains the list of words as shown in below image

To add the prefix, use the formula as "message" & Address of cell

In our case, the formula will be ="NIRMAL-"&A2

Now click the empty cell where you want to get the result and enter the formula as ="NIRMAL-"&A2 and press Enter to get the first result as shown below.

Step 2:

You can display all the other results just by dragging down from the corner of the first result till all the results are filled. The final output will look like the one shown below:

How to Add suffix into Cell Values?

Let see a simple process to add suffix into cell values.

Step 1:

Let us consider the same data which we used in the above example. To add the prefix, use the formula as Address of cell "message". In our case, the formula will be =A2&"-NIRMAL"

Now click the empty cell where we want to get our result and enter the formula as =A2&"-NIRMAL" and press Enter to get our first result as shown below:

Step 2:

Display all the other results just by dragging down from the corner of the first result till all the selected cells are filled with the new values.

How to Add Both Prefix and Suffix into Cell Values?

Let see a simple process to add both prefix and suffix into cell values

Step 1:

Let us consider the same data which we used in the above example. To add both prefix and suffix, use the formula as "message" Address of cell "message". In our case, the formula will be ="Mr-"&A2&"-NIRMAL"

Now click the empty cell where you want to get the result and enter the formula as ="Mr-"&A2&"-NIRMAL "and press Enter to get the first result, as shown below:

Step 2:

Then, you can display all the other results just by dragging down from the corner of the first result till all the selected cells are filled with the new values. The output will look similar to the one shown below:

How do you add a prefix in sheets?

How do you type a prefix in Google Docs?

How do I put a word in front of every cell in Google Sheets?