Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting data from one column into two
Hi,
Is it possible to split text or other type of data from one column into two? Two examples: A Brown dog Yellow bird etc.. into: A B Brown dog Yellow bird Thanks in advance. Marieke |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting data from one column into two
datatext to columns
-- Don Guillett Microsoft MVP Excel SalesAid Software "mariekek5" wrote in message ... Hi, Is it possible to split text or other type of data from one column into two? Two examples: A Brown dog Yellow bird etc.. into: A B Brown dog Yellow bird Thanks in advance. Marieke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting data from one column into two
--Select the range ColA
--From menu DataText to ColumnsDelimitedNextSelect Space and OK If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: Hi, Is it possible to split text or other type of data from one column into two? Two examples: A Brown dog Yellow bird etc.. into: A B Brown dog Yellow bird Thanks in advance. Marieke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting one column into two | New Users to Excel | |||
Splitting single column data into two | Excel Worksheet Functions | |||
Splitting Column Data into 2 fields | Excel Worksheet Functions | |||
splitting data from 1 column into multilple? | Excel Worksheet Functions | |||
splitting 1 column of data into multiple columns | Setting up and Configuration of Excel |