Seperating Data in a single field (1 Viewer)

[jsanders]

Sorry for this totally stupid question but my memory is just not what it once was.

I need to separate one field into two, in a table that was imported from excel

Basically it has a size and a unit in each field

Example:

24.67 sy
26.84 sf


Thanks in advance for jogging an old man's memory.

I want to do this in a query not code if possible I remember something about a formula you can enter into the update to box in a saved query.

 

[EndersG]

Using a table named Table1 with the following values:

SizeUnit
24.67 sy
26.84 sf

I created a query that returns the following results:

SELECT SizeUnit, Val([SizeUnit]) AS [Size], Mid([SizeUnit],InStr([SizeUnit]," ")+1) AS Unit
FROM Table1;

SizeUnit Size Unit
24.67 sy 24.67 sy
26.84 sf 26.84 sf