strings with space

A

an

Hello!

I have in column, strings such as:

x xxxxxxxxxxxx
xxxx xxxxxxx
xxxxxx xxxxx
xx xxxxx

I would like to extract left group of characters to a
column, and 2nd group to another column.

Please, is it possible with Excel function?

Thanks in advance.
an
 
D

Don Guillett

Have a look in HELP index for FIND. Then, use in conjunction with LEFT and
RIGHT
 
D

DDM

An, use the Text to Columns command on the Data menu. Your text is
delimited, with a space as the delimiter.
 
Top