Trim

[Dan]

i have a table and want to trim some data off
for example

1. John Jones
2. Frank Smith

i want to get rid of everything to the left the 1. and 2.

 

[Guest]

Maybe this is too complicated, but it will work:

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

InStr looks for first blank space in the string and then uses the position +
1 (to eliminate the blank space) in Mid function (no length needed).

Hope this helps.

Luke