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

D

deonderd

Hi

i have an excell cheet .. one column provides the information.. i wan
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
 
P

Paga Mike

deonderd;1610127 said:
Hi

i have an excell cheet .. one column provides the information.. i wan
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?
Click to expand...


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to seperate a text group in once cell into many cells 2
How can I edit a protected cell to enter a value manually and thenprotect it again (automatically) 7
How do I copy the contents of a range of text cells and paste into one cell? 7
How can I attach a combobox to a cell and have it resize if the column width is alterd 1
How can I copy a value from a cell and paste it into another cell while adding it to the previous va 2
How do I put a watermark under cells in excel and make it print? 1
How can I add a single letter to text already in a list of cells? 3
to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . 3

Top