Add a Character to every cell in Microsoft Excel 2010

Sometimes we need to add a "Prefix" & "Suffix" to 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.

img1

 

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

img2

 

    • Click on Format Cells orPress Ctrl+1Shortcut key to open the Format Cells dialog boxdirectly without using the right clck option.

img3

 

    • Select the Number tab if not already active, and from Category select Custom.

img4

 

    • In the Type box, enter the following Custom Formatting syntax: \A#

img5

 

  • This is how our result will look.

img6

 

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.

img7

 

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

img8

 

    • 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.

img9

 

    • Select the Number tab if not already selected, and from Category select Custom

img10

 

    • In the Type box, enter the following Custom Formatting syntax: # "Files"

img11

 

  • This is how our result will look -

img12

 

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

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube