hiii
how is every1?
im sorry for my bad title, but i cant describe my issue there...
here is my problem
1st its a big a clinic..
i have an excel sheet with almost 5000 entries..
with many columns named as usual..
one column is called MEDICINE, which goes under it the prices of medicine in the pharmacy..
this column has the data like this : 27.65
24.70
91.45
but the problem isnt here, its in some cells, that contains more than one value and it has the total appearing e.g: =450+27.65
=140+60.95
=600+85.70 of course bcz i made an = at beginning so it will show me the total..
what i need is HOW TO SEPARATE those values in different columns?
please help me..!
thnx alot in advance..
Bookmarks