add prefix to numbers in range in Excel

Q5. In Excel, how can I add a Prefix to a set of numbers in a range?

For example, as seen in attached screenshot, a given worksheet has a set of Serial Nos corresponding to non conformances observed in a Quality audit. At a later time, you decide to add a prefix "NC-" (denoting Non Conformance)

to all the S.Nos. Manually adding the Prefix is a tedious process especially when there are large number of records.

excel add prefix to numbers in range

To do it in Excel, here is the answer:

To add a prefix to a range of numbers,

a) Select the range of cells, right click and then select "Format Cells".

excel excel add prefix to numbers in range

b) Select "Custom" under "Number" tab. In the "Type" field, enter the prefix in quotes (in this case "NC-") followed by # symbol. Click OK.

excel excel excel add prefix to numbers in range

c) All the numbers in the range selected would be prefixed appropriately (in this case the numbers would be prefixed with "NC-").

excel excel excel excel add prefix to numbers in range

 

You can find similar Excel Questions and Answer hereunder

1) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

2) How can I add interval to dates?

3) How can I dynamically add series to an existing chart using VBA?

4) How can I quickly remove all blank cells in a data range?

5) How do I get the 2nd highest number in a range of numbers?

6) How can I add Trendline to a chart using VBA?

7) How can I add a WorkSheet and name it as required using VBA?

8) How do I enter a formula in a cell using VBA (using Absolute Reference)?

9) How can I add a Footer to my printout with automatic page numbering?

10) Can I change the way that huge numbers are displayed in Y-Axis so that they do not take up chart space?

11) How do I add a shape using VBA?

12) How can I clear all formats (formats alone not data) from a range of cells?

13) How can I add a legend to a chart using VBA?

14) How can I remove hyperlinks from a range of cells?

15) Is there a way to easily shade alternate rows in a data range for improving readability?