| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i SUM data in Excel ex:email that contains "Numbers and Text"???
Ive been trying different ways all day to get this to work..thats how i
found this thread..nothing ive tried off of here so far has worked and im sure its simple and the answer is here somewhere but my eyes are starting to go the shape of my monitor.. The problem is... i recieve data in email ...copy n paste to Excel ...try to SUM but blahhh.. Snapshot of part of a column im trying to SUM 1.32 DR 1.34 DR 1.42 DR 0 i got the following formula off of one thread and it worked with data i typed into cells manually but did not work with the data pasted from =SUM(IF(ISNUMBER(--SUBSTITUTE(UPPER(A1:C1925),"V","")), --SUBSTITUTE(UPPER(A1:C1925),"V",""))) ive tried copying clear cell.. special paste ..values /add...still no good.... where to next??? Any thoughts greatly appreciated. Regards Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| How can I convert numbers (ex. "4") to text (ex. "four") | Excel Discussion (Misc queries) | |||
| Excel 2007 - Email as "Body Text" | Excel Discussion (Misc queries) | |||
| Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
Threaded Mode
