Ask Experts Questions for FREE Help !
Ask
    vikramjagtap's Avatar
    vikramjagtap Posts: 1, Reputation: 1
    New Member
    		  
    #1

    May 13, 2009, 11:13 PM
    Excel text formula
    Hi,

    Please provide me the formula to convert names in to email address, for example -
    "William Smith" should be converted in to "[email protected].

    Thanks in advance
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    May 14, 2009, 01:44 AM

    Please provide a more complete example of your actual names. Are ALL names supposed to be converted to gmail addresses?

    The most notoriously inconsistent dataset is a list of people's NAMES. Names are 1,2,3,4 and even 5 words. Are your names strictly First/Last?

    Are the names in separate cells? What columns?

    If all names are not supposed to be GMAIL addresses, then what column holds the ISP name?

    You can click on GO ADVANCED and use the paperclip icon to upload a good sampling of your actual data. Try to show all the problems that you face in the sample data.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    May 27, 2009, 09:18 AM

    Please present the formula from that collection you are advertising that directly relates to this thread and question...
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

I need a excel formula [ 2 Answers ]

Hi I need a excel formula for numbers ( Figures) are convert in words. Like Rs.20 =Twenty only( In Formula) up to 15 digit. Thanks Regards Hariom

Excel formula [ 1 Answers ]

I have more questions about excel formula. In one column I have data appearing, as either a 1 or 2, at random as I input it. Each column has around 120 rows. In the row at the bottom I created a formula to calculate how often, on average, the data appears in that column. 1st how do I get each row...

Excel formula [ 3 Answers ]

I am using Excel 2007. I have 2 Sheets. In first sheet there are 3 coloumns, first one contains the employes number, second coloumn contains the name of employes and third one contains the department he works in. In the second sheet I have drop down list of the names of employes and the...

Excel formula [ 3 Answers ]

I have a column that you manually enter a number; either 0 (zero) or any number greater than zero. I have another column with the formula of: =DAYS360(AN22,AQ22) If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: $0.00 But...

View more questions Search