View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default spit & sum comma delimted value

On Sep 8, 4:06*am, Francois Taljaard
wrote:
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.



just click F2 and enter