Previous Topic Next Topic

Copy field to end of another field

Solved/Closed
Marc - Sep 29, 2008 at 10:55 AM
 Marc - Oct 1, 2008 at 07:04 AM 
Hello,



I would need a macro that would help me copy caracters in colomn A to the end of what is in colomn B.

Can anyone help me please?



Ex: 



2062-6-6S  	FITTING HYDRAULIC



I want it to appear as follows;



2062-6-6S	                FITTING HYDRAULIC 2062-6-6S





Thanks            
                

    
    

    
            

            

    

    
    

        Related:         
    




    

        
        

                
1 response

        

        
    


            

        
        
        

                        Answer 1 / 1
        


        
                    

                

        

                    

        


     
             

            
    
    

            

    


        
        

                

        


     
             

                    Ivan-hoe
    
        
    
                    Posts
            
                


     
             

            433
        
            
                            Registration date
            Saturday February 16, 2008
                            Status
            Member
                            Last seen
            October 17, 2008
            

            


     
             

                    110
    
        

                    

                    Sep 30, 2008 at 03:48 PM
                        

    


    

                        

                    Hello Marc, 

you don't even need a macro. Use a formula instead : 

C1 =B1 & A1

or

C1 =B1 & " " & A1 if you want a space in between

then Copy/ Paste Special / Values

Ivan
                
                

    
        

    
            
        1
        
            
                
    

            



    

        
        
    


        

        


    




        

                    

                    


                
        
    
    

        



    

                    

    
        
    
    

            

    


    
    

                

    Marc


    

    Oct  1, 2008 at 07:04 AM

    






    Hello Ivan,



Thankyou very much for your response. This will help me out greatly.



Thanks again.



Marc
    




    
 
    
        
    0

                    
        
    
    

            



    

        
        
    



    

    
            

        

            

        

    



    
Similar discussions

                                                    

                
                    Auto clear input field
                    

                        
    
    

            

    


                        

                                                                                    thimk -  

                            
                                                                                    loydie - 
                        

                    

                    

                    

                        5 responses