Splitting data...

[Snowmonster]

Hi all...

I know that you can add two sets of information, I.E. A1 = Ade, B1 = Snow, if you write =A1&B1, it's add the two together in a cell, leaving you with Ade Snow, is there a way of doing the reverse, without using VBA?

Snowmonster

 

[VoG]

One way is to use Data > Text to Columns, delimited with Space as the delimiter.

Or a formula

Excel Workbook
	A	B	C
1	Ade Snow	Ade	Snow
Sheet2

 

[Snowmonster]

Top, thanks a bundle...

 

[Snowmonster]

One way is to use Data > Text to Columns, delimited with Space as the delimiter.

Or a formula

Excel Workbook
	A	B	C
1	Ade Snow	Ade	Snow
Sheet2

Problem....
Tried to do it with a time, I.E. 12:45:00, but it states that it's the wrong data type in A1, any way around this...

Snowmonster

 

[VoG]

There are built in functions for splitting times (and dates)

Excel Workbook
	A	B	C	D
3	12:45:00	12	45	0
Sheet2

 

[Snowmonster]

You are a star, thanks a bunch...