# Insert/Put Period/Dot/Decimal/Point Before A Value In Excel

In this post we will see how we could insert a period/dot/decimal before a value in excel.

There are instances in which we are required to put point/decimal/dot or any character at the beginning of a value in excel.

We will see how to add a period at the beginning of any value irrespective of what is the type of value whether its text or numerical value.

Below is actual data in column A and column B data showing dot at the beginning of every value in cells in excelling. It’s a very simple task to prefix any value in a cell with a dot/period/decimal.

You could see that we have considered both numeric and text values.

We will use concatenation operator ampersand “&” in excel to add a dot before a value.

Step 1

Enter the formula =”.”&A2 in cell B2 as shown in the pic below. Step 2

Now drag the formula to accommodate all the data in column A as shown in the pic below. As you could see, we have prefixed all the values in column A with a dot in excel.

To Insert any character/number before any values in excel, just replace the dot in our formula with the character/number that you want to add as a prefix in excel.

E.g. if I want to add a prefix of “@” , then I would use the formula =”@”&A2.

Hope this helped.

Share The Knowledge
• #### Random Posts

• Insert Symbol In Excel

There are times when we want to insert some special symbol or characters in excel. We will see how we […]

Share The Knowledge
• Extract Numbers After A Character In Excel

Let’s see how we could easily extract all the digits after a character in excel. There are several occasions in […]

Share The Knowledge
• Print Cell Height And Cell Width Of A Cell In Excel

print cell’s dimension in excel , print row height and row width in excel, get row height and width of a range in excel, excel formula to get cell’s height and width, find dimension of a cell in excel

Share The Knowledge
• Extract Domains From URLs In Excel

Let’s see how to extract the domain name from the URL given, extracting the domain name from the URL is […]

Share The Knowledge