| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add numbers accross columns after stripping away text
I have the following data in a spreadsheet:
A1 B1 C1 D1 E1 F1 4.5f 6f 3.5f 3f 7.25f I need to be able to add the numbers together to give me 24.25, i.e. strip the fs away. The numbers will always be less than 10 and the there will only ever be .25 or.5 or .75 after the number (I don't know whether that is significant?). If anyone can show me how to do this I would be very grateful. I have been messing around with MID and FIND to no avail and then started thinking that SUMPRODUCT might have to get involved but it all got a bit much for me! There may be a perfectly simple solution which I have overlooked! Regards, Gavin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting differences in numbers across columns | Excel Worksheet Functions | |||
| identify numbers which are listed in two columns. | Excel Worksheet Functions | |||
| How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
