| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto-Fill Column based on data in each row
+"StaticText"&A1
"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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto-Fill Column based on data in each row
Hi dave
In C1 enter ="Static Text"&A1 If you want and space betwenn text and the numbers use ="Static Text"&" "&A1 In this helps please click yes, thanks "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto-Fill Column based on data in each row
That worked like a charm! Thanks to all of you.
"Fluke" wrote: +"StaticText"&A1 "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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto-Fill Column based on data in each row
Fluke's and Eduardo's answers are identical, with the exception of the first
character. Are the + and = interchangeable or are any differences just not manifesting themselves in my particular situation? Just curious. Thanks to both of you. "Fluke" wrote: +"StaticText"&A1 "Eduardo" wrote: Hi dave In C1 enter ="Static Text"&A1 If you want and space betwenn text and the numbers use ="Static Text"&" "&A1 In this helps please click yes, thanks "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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto-Fill Column based on data in each row
The + and = are the same thing - they just tell it you're entering a formula.
"Dave" wrote: Fluke's and Eduardo's answers are identical, with the exception of the first character. Are the + and = interchangeable or are any differences just not manifesting themselves in my particular situation? Just curious. Thanks to both of you. "Fluke" wrote: +"StaticText"&A1 "Eduardo" wrote: Hi dave In C1 enter ="Static Text"&A1 If you want and space betwenn text and the numbers use ="Static Text"&" "&A1 In this helps please click yes, thanks "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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto-Fill Column based on data in each row
"Eduardo" wrote: If you want and space betwenn text and the numbers use ="Static Text"&" "&A1 ........ ="Static Text"&" "&A1 can simplier to : ="Static Text "&A1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to auto add data based on value in another column | Excel Discussion (Misc queries) | |||
| auto fill rows with months based on cell value | Excel Discussion (Misc queries) | |||
| auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
| Auto fill Column based on data in other columns | New Users to Excel | |||
| How to have Excel Fill In Data in Column based on another columns | Excel Worksheet Functions | |||
Linear Mode
