MS Excel help

[SO16_Saint]

this should probsbly go in the tech form, but hey..

I need to concentate a column of user ID's and add the @company and .com suffix in a separte column to make up an email address (abc@company.com)

the issue I'm having is you can normally do this once, and then drag down the black cross so it auto-fills the rest, but it's not working for me now?

I know there's a way of using the $ sign, but not sure how....

can anyone help?

[Chopper71]

I think you mean concatenate. Formula should be =concatenate(A1,"@company.com")

The $ symobol means that if you drag the field through the colums it will always bring in the cell immediately after the $ - e.g. A1 would always be displayed no matter what the row.

[SO16_Saint]

thats the one, Chopper.

I have info in C and the @ sign in S3 and .com in T3

=CONCATENATE(C2,S3,T3) where should the $ go in this formula?

[Ekelund24]

Between the Letter and the Number ie C$3 etc

[SO16_Saint]

Between the Letter and the Number ie C$3 etc

i could kiss you

[Ekelund24]

i could kiss you

Happy to help with Excel hints :-)

No kisses required lol!!