strings with space

[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

 

[Ron de Bruin]

Hi An

Use Data Text to columns in the Menu Bar

 

[Don Guillett]

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

 

[DDM]

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

 

[an]

Ok!
Many thanks at all.
an