Multiply number by text

[learningstatistics]

I am trying to create combinations and I have a matrix that look like that:
[TABLE="width: 500"]
<tbody>[TR]
[TD]E[/TD]
[TD]W[/TD]
[TD]O[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


I want to have it look like that:

[TABLE="width: 500"]
<tbody>[TR]
[TD]1E-2W-0o-3N[/TD]
[/TR]
[TR]
[TD]3E-2W-1o-1N[/TD]
[/TR]
[TR]
[TD]1E-2W-0o-0N[/TD]
[/TR]
</tbody>[/TABLE]

 

[mikerickson]

If "E" is in A1

Then you could put this in E2 and drag down

=A2&A$1&"-"&B2&B$1&"-"&C2&C$1&"-"&D2&D$1

 

[learningstatistics]

That helps! Thanks a lot mikerickson.