SO16_Saint Posted 12 July, 2012 Share Posted 12 July, 2012 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? Link to comment Share on other sites More sharing options...
Chopper71 Posted 12 July, 2012 Share Posted 12 July, 2012 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. Link to comment Share on other sites More sharing options...
SO16_Saint Posted 12 July, 2012 Author Share Posted 12 July, 2012 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? Link to comment Share on other sites More sharing options...
Ekelund24 Posted 12 July, 2012 Share Posted 12 July, 2012 Between the Letter and the Number ie C$3 etc Link to comment Share on other sites More sharing options...
SO16_Saint Posted 12 July, 2012 Author Share Posted 12 July, 2012 Between the Letter and the Number ie C$3 etc i could kiss you Link to comment Share on other sites More sharing options...
Ekelund24 Posted 12 July, 2012 Share Posted 12 July, 2012 i could kiss you Happy to help with Excel hints :-) No kisses required lol!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now