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.