Difference between revisions of "Q. How do I add prefix/suffix to Order and Result code columns in my SSMT Excel spreadsheet?"
Jump to navigation
Jump to search
(Created page with '1. Insert a column for applying formula File:Concatenate1.jpg 2. Select the cell in that new column for the first row to which you will be applying the formula [[File:Conc…') |
|||
Line 1: | Line 1: | ||
− | 1. Insert a column for applying formula | + | 1. Insert a column for the prefix/suffix and another for applying the formula. Make sure the cells are formatted to General. |
[[File:Concatenate1.jpg]] | [[File:Concatenate1.jpg]] | ||
− | 2. Select the cell in that new column for the first row to which you will be applying the formula | + | 2. Select the cell in that new column for the first row to which you will be applying the formula. |
[[File:Concatenate2.jpg]] | [[File:Concatenate2.jpg]] | ||
− | 3. Select | + | 3. Select Formulas, Text, Concatenate formula. Function Arguments window opens. |
[[File:Concatenate3.jpg]] | [[File:Concatenate3.jpg]] | ||
− | 4. In this example, enter A2 in Text1 field and B2 in Text2 field | + | 4. In this example, enter A2 in Text1 field and B2 in Text2 field. |
[[File:Concatenate4.jpg]] | [[File:Concatenate4.jpg]] | ||
− | 5. Click OK | + | 5. Click OK. |
[[File:Concatenate5.jpg]] | [[File:Concatenate5.jpg]] | ||
− | 6. | + | 6. Select the cell and drag to fill in remaining cells below. |
[[File:Concatenate6.jpg]] | [[File:Concatenate6.jpg]] | ||
+ | |||
+ | 7. Copy the cells and paste Values. | ||
+ | |||
+ | [[File:Concatenate6.jpg]] | ||
+ | |||
+ | 8. Delete the columns you added. |
Revision as of 18:11, 21 February 2013
1. Insert a column for the prefix/suffix and another for applying the formula. Make sure the cells are formatted to General.
2. Select the cell in that new column for the first row to which you will be applying the formula.
3. Select Formulas, Text, Concatenate formula. Function Arguments window opens.
4. In this example, enter A2 in Text1 field and B2 in Text2 field.
5. Click OK.
6. Select the cell and drag to fill in remaining cells below.
7. Copy the cells and paste Values.
8. Delete the columns you added.