PDA

View Full Version : Adding a common value to a column using VBA



Chris123
12-16-2014, 10:41 AM
*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.

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

SamT
12-16-2014, 11:52 AM
@ All: See: Adding a common value to a column. (http://www.vbaexpress.com/forum/showthread.php?51377-Adding-a-common-value-to-a-column)

Chris, (I think that) I answered the question at the Mac Users Forum link above.