trim to first "-" character

K

Keith

Sorry if this is posted again, but I couldn't find my post.

How do I trim off everything to the left of the first "-"? The number of
spaces are different (to the left of the first "-") so I'm hoping there's a
way. There's always a way!


(abc) -PLhagdr-hdk
(ded ) -GHld-usj
(ab) -hgrh-isjb

Results would be:
PLhagdr-hdk
GHld-usj
hgrh-isjb
 
X

xps35

Sorry if this is posted again, but I couldn't find my post.

How do I trim off everything to the left of the first "-"? The number of
spaces are different (to the left of the first "-") so I'm hoping there'sa
way. There's always a way!

(abc)   -PLhagdr-hdk
(ded ) -GHld-usj
(ab)  -hgrh-isjb

Results would be:
PLhagdr-hdk
GHld-usj
hgrh-isjb
Click to expand...

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

Groeten,

Peter
http://access.xps350.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim 1
First Character to Lowercase 2
Hyperlink to email: cut off after first space character 1
How do you trim characters? 6
Sorting and using the first criteria 5
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
trim trailing spaces on data in a text box 3
Error in Microsoft Encryption Sample? 2

Top