Enter and replace partial value in two cells
Closed
                                    
                        Chuck                    
                                    -
                            Dec 14, 2009 at 09:32 PM
                        
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 15, 2009 at 07:00 AM
        venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 15, 2009 at 07:00 AM
        Related:         
- Enter and replace partial value in two cells
 - How to enter @in laptop - Guide
 - Partial match excel - Guide
 - How to enter bios - Guide
 - How to enter in wechat - Guide
 - Replace abbreviation - Guide
 
1 response
                
        
                    venkat1926
    
        
                    Posts
            
                
            1863
                
                            Registration date
            Sunday June 14, 2009
                            Status
            Contributor
                            Last seen
            August  7, 2021
            
            
                    811
    
    
                    
Dec 15, 2009 at 07:00 AM
    Dec 15, 2009 at 07:00 AM
                        
                    copy this formula in A5
="I live in["&A1&"]"
be careful about double quote (")
whatever you change in A1 it will be automatically incorporated in A5
            ="I live in["&A1&"]"
be careful about double quote (")
whatever you change in A1 it will be automatically incorporated in A5