MS Excel Question

[DeathOnSight]

Hi guys,im hoping you can assist with this problem

Basically what im trying to do is simplify a conversion process on an excel spreadsheet

I want users to paste the name in column A and add "@mydomain.com" in column B with the following formula =A1&"@mydomain.com" - this displays what i want,except its still a formula.

now i need a formula that will take the contents of column B and display that as plain text

Is that possible?I know theres the option to select all,copy and paste as values,but is there a formula that simplifies this process (I get alot of telephone calls to do this as users dont grasp the concept of selecting all and changing it that way)

Preferably would like to create a template,they just add names to column A and it auto populates he info or thats the idea

Thanks

 

[JazzeD]

Easiest is to use concatenate


=CONCATENATE(A1, "@mail.com")

 

[Fudzy]

Or use the & symbol

Assuming that all the addresses are in column A and you want to add @mail.com to the end

Put this in column B:

=A1&"@mail.com"

I would suggest copying all the cells after that and do a Paste Special -> Values in another column to paste it as 'raw text'

 

[AlmightyBender]

Eish I don't think that there is a way around it that is simple. A formula is a formula and you would need to paste the values to get the values

 

[JazzeD]

Oops misunderstood the question. Read it way to quick.

But if users copy and paste it into a mail or any other document it would paste the value by default only.

 

[Traq]

If you use Excel 2013, then you can make use of the flash fill functionality as well.

 

[DeathOnSight]

Ah it was worth a shot,thanks for the ideas guys.
i figured once the formula was in,i would just have them save it as a CSV file,it retains the text value of the created address without the formula