Sometimes we need to add a Prefix&Suffixto existing data to clearly indicate what the data pertains to and make it more understandable to the reader.

If you want to add certain text in every selected cell beforeor after the original cell text, you can follow these steps, rather than editing each cell individually. This will save you considerable time as well.

Let us understand thePrefix part:

  • We have some numbers in columns A & B. Let us consider that we want to prefix each number in column B with letter “A”.
  • Column A contains numbers formatted using the General Format.

  • Select cells in range B4:B5 &right click on the mouse.

  • Click on Format Cells orPress Ctrl+1Shortcut key to open the Format Cells dialog boxdirectly without using the right clck option.
  • Select the Number tab if not already active, and from Category select Custom.
  • In the Type box, enter the following Custom Formatting syntax: A#

  • This is how our result will look.

1 (4)

Here we have used “A” as the prefix. Hence, it appears in the format applied. You can replace it with whatever text you want as the prefix.

Now, let us understand the Suffix part:

  • We have some numbers in columns A & B.Let us consider that we want to add the text “Files” to the end of each number in column B.
  • Column A contains numbers formatted using the General Format.

 

  • Select the cells in range B4:B7 &right click on the mouse.

  • Click on Format Cells orPress Ctrl+1shortcut key on the keyboard to open the Format Cells dialog box if you do not want to use the right click menu.
  • Select the Number tab if not already selected, and from Category select Custom
  • In the Type box, enter the following Custom Formatting syntax: # “Files”

1 (6)

  • This is how our result will look –

1 (7)

Here, you will see the text “Files” appearing after each number in column B.

Courtesy: Excel Tip by Maitrey Kapadia

Leave a Reply

Your email address will not be published. Required fields are marked *

3 − two =

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