string

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

kevcar40

Hi
a user is required to enter a part code this code is 14 char long
ie. Abcd-1213-45678
However some users are entering this code as without the dashes
ie Abcd12345678
How can i check this string for dashes ignoring if they are there and
puting them there if not

giving an end result of Abcd-1213-45678


thanks

kevin
 
Hi kevcar40,

The example you have supplied contrasts with the rule (14 chars), but if the
structure of the partnumber is fixed, such as 4-4-6 or similar, I think you
can benefit from applying a mask, which disallows the entry of anything but
letters and digits. Search for "mask" in help.

Good luck,
Engin
 

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

Macro for expanding a range 5
How to make string align by string.Format() in CJK? 4
Bold a vba string line (_) 3
how to change format of data already entered 5
Trying to Locate position of a DASH "-" in Cell or String 1
Text Formats 4
Formatting Text Problem 5
Query to take count and find most likely 4

Back
Top