Previous Topic Next Topic

Converting Specific Text Data to = # value

Closed
AphroHeidi - Mar 5, 2009 at 12:19 PM
 AphroHeidi - Mar 5, 2009 at 12:26 PM 
Hello,



I am trying to take a column that has the name of a plan type (e.g. The Fun Plan 25) and make it so the column next to it automatically recognizes that "The Fun Plan 25" is $433.00.   I want to take a column of eight or so different plans and have the prices automatically show in the column next to it for averaging purposes...can you hlep me out?  I appreciate any advice you have!!!  I have a huge amount of data to hand type if I don't get some help on this...thanks so much!            
                

    

        



            

                
                
            

            

    

    
            

            

    

    

        
        

                
1 response

        

        
    


            

        
        
        

                        Answer 1 / 1
        


        
                        
                    

                

        

                    

        
    
    

            

    

        

            AphroHeidi                    

                    Mar  5, 2009 at 12:26 PM
                        

    


    

                        

                    I am not sure why it says Windows 200 for my configuration....that is actually Windows 2007...iit might make a difference...thanks again!
                
                

    


            
    

        
        
    


        

                

                    

        

    

        

            
        

    

    

    

        

    

    
    





    
Similar discussions

                                                    

                
                    help me to add particular cells
                    

                        
    
    

                
            

    


                        

                                                                                    mathewmunna -  

                            
                                                                                    mathew munna - 
                        

                    

                    

                    

                        2 responses
                    

                
            

                                                        

                
                    Clear cell contents based on value of another cell range using VBA
                    

                        
    
    

            

    


                        

                                                                                    Tbonekiller -  

                            
                                                                                    Tbonekiller - 
                        

                    

                    

                    

                        6 responses
                    

                
            

                                                            

                    

    
    

        
        
    

                

                        

                
                    how to convert ounces (oz) to milliliter
                    

                        
    
    

            

    


                        

                                                                                    JPortillo -  

                            
                                                                                    vcoolio - 
                        

                    

                    

                    

                        1 response
                    

                
            

                                                        

                
                    Ig stories from close friends to public
                    

                        
    
    

            

    


                        

                                                                                    Darren -  

                            
                                                                                    zara - 
                        

                    

                    

                    

                        31 responses
                    

                
            

                                                        

                
                    Return Seq Values Until Blank value then return different set of seq values
                    

                        
    
    

            

    


                        

                                                                                    lorieb63 -  

                            
                                                                                    TrowaD - 
                        

                    

                    

                    

                        1 response