| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding text columns
Hi,
If your data is a column something like 0001 0002 0001 0023 0014 then try =SUM(VALUE(A1:A5)) entered as an array formula with Control-Shift-Enter Dave url:http://www.ureader.com/msg/104234935.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding columns | New Users to Excel | |||
| Adding Columns | Excel Discussion (Misc queries) | |||
| Adding Dashes in front of text using text formating | Excel Discussion (Misc queries) | |||
| Adding Text from seperate columns | Excel Worksheet Functions | |||
| Linking text columns with text and data columns | Excel Worksheet Functions | |||
Threaded Mode
