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

                                                    

                
                    Convert a date field in excel to day of week
                    

                        
    
    

            

    


                        

                                                                                    C -  

                            
                                                                                    Indian - 
                        

                    

                    

                    

                        7 responses
                    

                
            

                                                        

                
                    ..to.... field in yahoo mail problem ..double mail received
                    

                        
    
    

            

    


                        

                                                                                    anthony -  

                            
                                                                                    anthony - 
                        

                    

                    

                    

                        0 responses
                    

                
            

                                                            

                    

    
    

        
        
    

                

                        

                
                    Copy rows from Excel to another sheet once a date in a specific field is filled
                    

                        
    
    

            

    


                        

                                                                                    lisav041475 -  

                            
                                                                                    vcoolio - 
                        

                    

                    

                    

                        16 responses