Thread: spit & sum comma delimted value
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Francois Taljaard[_2_] Francois Taljaard[_2_] is offline
external usenet poster
  
Posts: 3
Default spit & sum comma delimted value
Hi muddan

try it before not sure if I'm doing something wrong.

A1: 20,301,21,302,0


I copy B1 (+20+301+21+302+0), then paste special, with Values checked and
then OK.

the result is +20+301+21+302+0.
Reply With QuoteReply With Quote