View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cy
 
Posts: n/a
Default How to change the following data

A B C A B
C
1 David 123 456 to David 789 000
2 789 000 CK 135
246
3 CK 135 246 CK 348 256
4 CK 348 256 Steve hij
kem
5 Steve abc efg
6 hij kem

Because i hv large amount of data,i don't want to copy and paste 1 by 1