data>> text to colums?

  • Thread starter Thread starter coldasice
  • Start date Start date
C

coldasice

I have large amount of data in many colums in this format

28-78
39-84
38-73
32-79

which I want to do some caculation with but before I can do that I have
to do text to colums to take out the "-". my problem is I have to do
this everytime I paste new in which is Data>> text to colums.. My
question is there anyway I can set a formula/format/ect so that
everytime I paste new data in without redo all the steps. Thanks
 
The formula depends on the calculation you wish to
perform. As an example, if you wanted to add the 2 numbers
together, you could use:

=LEFT(A1,2)+RIGHT(A1,2)

HTH
Jason
Atlanta, GA
 
Thanks for your reply Jason.

is it possible if I want to do AVG function using your formula?
 
Back
Top