| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Quote:
You could use Text to Columns with the ; as a separator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract just text from cells | Excel Worksheet Functions | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| excel, can put name in one cell and get ther# in the next cell? | Excel Worksheet Functions | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| If Cell equals text Copy Cells, B2,B3,B4 | Excel Programming | |||
Linear Mode
