Al Ikram Amit
In this article, we will demonstrate how to create price tags in Excel with a sample data column. Remember one thing, you can change the data according to ways that will serve your purposes. For example, if you require a barcode in the Price Tag, please visit this post on our website ExcelDemy, and add it to your column.
Download Practice Workbook
You can download the practice workbook from the following download button.
Steps to Create Price Tags in Excel
Suppose we have Sample Data of Product, Product ID, Type, and Price that are required to create a price tag. First of all, we will add extra columns other than the aforementioned types of columns to create a price tag in Excel.
⦿ Step 1: Add Extra Columns to Join the Text
- First of all, we will create columns with Title and sample side by side like the followings:
Product: Product-1
Product ID: DF434893
Type: Big Sale
Price: $20
- To do so, we will use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
- So, to do the functionality, we will enter the following equation in cell G5.
=TEXTJOIN(": ",TRUE,$B$4,B5)Here,
“: “= Delimiter Argument
TRUE= Ignore Empty Cells
$B$4= Product
B5= Product-1
➽ Result: Product: Product-1
- So now, drag the fill handle downwards to complete the series.
- Secondly, we will use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
- Now, to do the job, we will enter the following equation in cell H5.
=TEXTJOIN(": ",TRUE,$C$4,C5)Here,
“: “= Delimiter Argument
TRUE= Ignore Empty Cells
$C$4= Product ID
C5= DF434893
➽ Result= Product ID: DF434893
- Again, drag the fill handle down to complete the sequence.
- Thirdly, we will again use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
- Now, we will enter the following equation in cell I5.
=TEXTJOIN(": ",TRUE, $D$4,D5)Here,
“: “= Delimiter Argument
TRUE= Ignore Empty Cells
$D$4= Type
D5= Big Sale
➽ Result= Type: Big Sale
- Further, we will drag the fill handle downward to complete the series.
- In this last column, we will use the TEXTJOIN function to combine Row 4 with the corresponding data in the other rows.
- Now, we will enter the following equation in cell J5.
=TEXTJOIN(": $",TRUE, $E$4,E5)Here,
“: $”= Delimiter Argument
TRUE= Ignore Empty Cells
$E$4= Price
E5= $20
➽ Result= Price: $20
- Again, like in the many previous steps, now, drag the fill handle downward to complete the series.
Read More: How to Add Tags in Excel (2 Simple Ways)
⦿ Step 2: Create Price Tags Within a Cell
- At this moment, we will combine cells from the extra columns and combine them under the Price Tag.
- We have used the following formula to serve that purpose.
=TEXTJOIN(CHAR(10),TRUE,TRANSPOSE(G5:J5))Here,
CHAR(10)= Line Break Argument
TRUE= Ignore Empty Cells
TRANSPOSE(G5:J5)= Cells from G5 to J5 will be transposed.
➽ Result= “Product: Product-1
Product ID: DF434893
Type: Big Sale
Price: $20″
- Last but not least, we will select the following Home >> Alignment >> Wrap Text.
- To see the full cell, we will double-click on the row like the image below. (Or use the AutoFit Row Height command.)
- Now to complete the Price Tag column, we will drag the fill handle down like in the image below.
- Like the following image, we will select multiple rows.
- Now double-click on the mouse when the Excel cursor turns into like in the following image.
- Now we have the Price tag column. Further, you can modify your tag according to your preference.
- Select a wide column, if not wide make it wide and select AutoFit Column Width.
- Again, select all rows and select AutoFit Row Height.
- Our final table containing data for the price tags is here as in the image below.
Read More: Smart Tags in Excel: Definition & Different Uses
Conclusion
Follow these steps and stages on how to create price tags in excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.
