LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to auto add data based on value in another column AlanMB Excel Discussion (Misc queries) 5 May 21st 08 12:25 AM
auto fill rows with months based on cell value Drew[_2_] Excel Discussion (Misc queries) 5 March 31st 08 08:40 AM
auto fill columns based on a selection ckane Excel Discussion (Misc queries) 1 May 4th 07 05:34 AM
Auto fill Column based on data in other columns SITCFanTN New Users to Excel 1 June 6th 06 09:04 PM
How to have Excel Fill In Data in Column based on another columns sskirvin Excel Worksheet Functions 3 March 31st 06 03:14 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"