-
Adding a common value to a column.
*first time attempting to use VBA
*mac excel 2011
Looking to add a common value within the range D1 to D8000 on Sheet1.
Example:
Current sheet contains the following;
D1 = 123
D2 = 583
D3 = 229
etc...to D8000
I need to add the letters "ALB" prior to each of these numbers. (They could be added at the end just the same, if there is a difference.)
What I need:
D1 = ALB123
D2 = ALB583
D3 = ALB229
etc...
(The "ALB" could be added at the end just the same, if there is a difference.)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules