Auto-Fill Column based on data in each row
="Static Text"&RIGHT(A1,3)
On 22 Maj, 15:25, Dave wrote:
I need to take an existing worksheet with 2 columns and automatically fill a
third column with some static text combined with the value in the first
column for each row.
Example:
Existing Worksheet
* * *A * * * * *B * * * *
1 123 * * *Desc * * *
2 321 * * *Desc
3 231 * * *Desc
Worksheet With Added 3rd Column
* * *A * * * * *B * * * * * * * * * *C * * *
1 123 * * *Desc * * * * * Static Text123 * * *
2 321 * * *Desc * * * * * Static Text321
3 231 * * *Desc * * * * * Static Text231
Any help is appreciated!
Dave
|