DataText to ColumnsDelimited by spaceNext.

Choose "do not import" after selecting column 2.


Gord Dibben MS Excel MVP

On Wed, 18 Jan 2006 09:34:32 -0600, T De Villiers
wrote:


Hi,

I need a function which does the following:

F1 FRED
F23 GHTYRFFFF
G1234 AD

becomes:
F1
F23
G1234

i.e Returns the characters before the space, many thanks