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

Paga Mike

Junior Member

Location: Lakehurst, NJ, USA

Posts: 19

Quote:

Originally Posted by deonderd

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?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to extract just text from cells	Access Joe	Excel Worksheet Functions	4	April 29th 08 09:06 PM
How do I copy the contents of a range of text cells and paste into one cell?	davfin	Excel Discussion (Misc queries)	7	July 4th 06 08:16 AM
excel, can put name in one cell and get ther# in the next cell?	jesse	Excel Worksheet Functions	1	June 15th 06 01:40 AM
How to I copy text from a range of cells to another single cell?	WRT	Excel Discussion (Misc queries)	2	December 18th 05 06:17 AM
If Cell equals text Copy Cells, B2,B3,B4	Djmask[_5_]	Excel Programming	5	August 20th 05 04:11 PM

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

Menu

About Us