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
|