Good morning.
I have a problem that I'm not sure whether it is possible for excel to fix. I have a program that will spit out data with a column that combines values and units. I would like to filter and total these values but since the units are listed in the same cell as the values I don't know how. What I am looking for is some function that can read the cell and filter out the unit leaving only the value in another cell. I can live with just pulling out the value but also pulling out the units would be handy.
I apologize for perhaps using some incorrect terminology as I am very much not an expert with excel and any assistance would be greatly appreciated. Thank you.
Bookmarks