View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Auto-Fill Column based on data in each row

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