Macros

D

Douggen

I want to add a short text string to the start of the existing text in a long list. For example, add "lab" to a list of laboratory results. So "CBC" becomes "labCBC", "Glucose" becomes "labGlucose", etc. Any suggestions on how to write a macro to do this? Thanks.
 
C

Cesar Zapata

You dont need a macro for this. A macro loop will take longer than a
formula.
try this.

Lets say your long list Starts in A1 then in B1 insert this


="lab"&A1

then fill down.


regards,
Cesar Zapata



Douggen said:
I want to add a short text string to the start of the existing text in a
Click to expand...
long list. For example, add "lab" to a list of laboratory results. So
"CBC" becomes "labCBC", "Glucose" becomes "labGlucose", etc. Any
suggestions on how to write a macro to do this? Thanks.
 
Top