How To Extract only the first four characters

[mr moe]

Hi, Everyone,
I have an excel column that has building location and building name in one column, example 1245 Accounting, how can I copy the 1245 into it's own column, please help, i can do it either in access or excel. Please.

 

[mhartman]

Here you go....

=LEFT(A1,4)

If your data Accounting1234 was in cell A1

Regards

 

[macca the hacke]

use the left string function - works in both excel and access.
ie. left([fieldname],4) in access - where fieldname is the name of the field you want the first 4 characters from

 

[mr moe]

Thank you guys. You saved me hours of typing. =left(A1,4) worked great.