How to add Character to multiple cells in Excel
![](https://spreadcheaters.com/wp-content/uploads/Dataset-How-to-add-Character-to-multiple-cells-in-Excel-.png)
Here we have a dataset which contains three columns, the first column contains names of the Fruit, Second column which is Price($) will contain Price combined with $ and Third column contains simple Price. Now we have to add character ($) with price to the Price($) column. To do this follow the steps below but first let’s have a look at the dataset above.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-add-Character-to-multiple-cells-in-Excel-.gif)
Adding a character or text to multiple cells in Excel is a common task that can save you a lot of time and effort. Whether you want to add a prefix, suffix, or a specific character to multiple cells, Excel offers several ways to accomplish this task quickly and easily.
Step 1 – Type the Formula
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-add-Character-to-multiple-cells-in-Excel-.png)
– We have used the Concatenate formula.
– Syntax of the formula is
=CONCATENATE(Value1, Value2)
Value1 and Value2 represent the different values you want to merge.
– In our case we want to merge Price with $.
For this tutorial formula will be
= CONCATENATE(D2,”$”)
Step 2 – Add character to the remaining cells
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-add-Character-to-multiple-cells-in-Excel-.gif)
– Once you concatenate the First cell, drag it from bottom right to the other cells
– Values will appear automatically according to the corresponding values.