Q. How do I add prefix/suffix to Order & Result code columns in my SSMT Excel spreadsheet?

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to: navigation, search

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:Concatenate2.jpg

3. Select the Concatenate formula. Function Arguments window opens

File:Concatenate3.jpg

4. In this example, enter A2 in Text1 field and B2 in Text2 field

File:Concatenate4.jpg

5. Click OK

File:Concatenate5.jpg

6. Copy that cell and Paste in remaining cells below

File:Concatenate6.jpg


Links

Back to Application Troubleshooting