text formulas?

  • Thread starter Thread starter sara
  • Start date Start date
S

sara

can anyone help me figure out how to do a formula in excel
where numbers aren't involved.

for example, i want to create a formula based on a text
string and the contents of two columns:

text string: "gv01"
column1: "AA" "AB" "AC", etc.
column2: "01" "02" "03", etc.

so, i want a resulting list to come out like:
row 1: gv01-AA-01
row 2: gv01-AB-02
row 3: gv01-AC-03

does that make sense?

any ideas on how to get that automated?

thanks!

sara
 
Sara,

One way to do it:

Assuming your data ("AA") starts in A1, enter i A4,

="gv01-"&OFFSET($A$1,0,ROW()-4)&"-"&OFFSET($A$1,1,ROW()-4)

and fill down as required.

HTH
Anders Silvén
 
don,

yep. that did the trick!

those pesky ampersands are what i was missing!

thanks for the help,
sara
 
Back
Top