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

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

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

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

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

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

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

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