View Single Post
  #1   Report Post  
deonderd deonderd is offline
Junior Member
 
Posts: 1
Default How can i extract certain text out a cell and copy it to ther cells

Hi

i have an excell cheet .. one column provides the information.. i want to seperate over columns.. eg


Cell N2 Akita GT42B

;Lengte = 413,1
;Breedte = 56
;Ø asgat = 10,4
;Ø zijgat = 8,1
;Afstand zijgaten (middelpunten) = 65,1

CP042013

I want to devide this information over different cells
SO O2 becomes Lengte = 413,1
P2 becomes Breedte = 56 and so on

how can i do this?