Thread: Adding text columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default 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
Reply With QuoteReply With Quote