S sukanta New Member Feb 28, 2013 #1 How to add a prefix in particular cell. Suppose if I put 11022103 it will automatically return 2211022103. Here I add 22 with my putting value. 22 will be same for entire column.
How to add a prefix in particular cell. Suppose if I put 11022103 it will automatically return 2211022103. Here I add 22 with my putting value. 22 will be same for entire column.
Hui Excel Ninja Staff member Feb 28, 2013 #2 You can either: 1. Use a helper column ="22"&A1 2. Use a Custom number format Select Column Ctrl 1 Format Number, Custom In the Type Box enter 22# If any cells will link to these numbers, use Method 1 If it's just for display or printing, use Method 2
You can either: 1. Use a helper column ="22"&A1 2. Use a Custom number format Select Column Ctrl 1 Format Number, Custom In the Type Box enter 22# If any cells will link to these numbers, use Method 1 If it's just for display or printing, use Method 2