breaking down string help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take the first 2 characters of a string to use in a code but if the
second character is ' as in o'brien i want to use the first and third
characters. how can i do this, Any help appreciated.

colm
 
IIf(Mid([MyString], 2, 1) = "'", Mid([MyString], 1, 1) & Mid([MyString], 3,
1), Left([MyString], 2))
 
You must log in or register to reply here.

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

Help with Code Please 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
"The field is too small..." error in form drop-down 1
Selecting Characters 2
Function instr 5
Continuous Form Control Setting (Select Case) 0
Pull part of data from a string 1
Excel Help creating Excel formula 1

Back
Top