Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DB design question 8
VBA Macro change column contents 4
question on macro 8
Text - Remove text Item No.99 (First 2 Chars) and move to end 5
Crash when using GetInspector 1
Calculating the first day of the week 5
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce 5
Commandbar question 1

Back
Top