Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Help
- Thread starter noitall
- Start date
Is the first 5 characters alway 4 numbers and a space? If so this formula will work:
Mid({YourField},6)
If you want everything to the right of the first space, try this formula:
Mid({YourField},Instr(" ",{YourField}) Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Mid({YourField},6)
If you want everything to the right of the first space, try this formula:
Mid({YourField},Instr(" ",{YourField}) Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question