ExcelBanter - How can i extract certain text out a cell and copy it to ther cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can i extract certain text out a cell and copy it to ther cells (https://www.excelbanter.com/excel-discussion-misc-queries/448358-how-can-i-extract-certain-text-out-cell-copy-ther-cells.html)

deonderd

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?

Paga Mike

Quote:

Originally Posted by deonderd (Post 1610127)

You could use Text to Columns with the ; as a separator

All times are GMT +1. The time now is 07:15 PM.