Remove Left Characters up to the first space

S

Sarah

I have a field that I need to remove the characters up to the first space.
How do I do this.

123 XXXXXX
2459 XXXXXX
5690 XXXXXXX
 
D

Douglas J. Steele

That'll leave the blank. To remove the blank, use

Mid([YourField], InStr([YourField], " ") + 1)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Van T. Dinh said:
Use

Mid([YourField], InStr([YourField], " "))

--
HTH
Van T. Dinh
MVP (Access)



Sarah said:
I have a field that I need to remove the characters up to the first space.
How do I do this.

123 XXXXXX
2459 XXXXXX
5690 XXXXXXX
Click to expand...
Click to expand...
 
Top