Creating email address with data from cell
Closed
                                    
                        Jen                    
                                    -
                            Sep  1, 2010 at 04:42 PM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:44 PM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:44 PM
        Related:         
- Creating email address with data from cell
 - Create snapchat account with email - Guide
 - Garena email address - Guide
 - Change outlook email address - Guide
 - Tmobile data check - Guide
 - Create skype account with work email - Guide
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Sep 1, 2010 at 06:44 PM
    Sep 1, 2010 at 06:44 PM
                        
                    if the first name and the last name are in the same column then , you need to replace space with a "."  and then add the "company.com"
=A1 & "@company.com"
or
=SUBSTITUTE(B4," ",".",1) & "@company.com"
            =A1 & "@company.com"
or
=SUBSTITUTE(B4," ",".",1) & "@company.com"