Replace worked perfectly!! THanks!
--- In AccessDevelopers@yahoogroups.com, "John Ruff" <[EMAIL PROTECTED]> wrote: > > You can use the Replace function in Access (Access2000 and above) > > > > PhoneNumber = Replace(PhoneNumber,"-","") > > PhoneNumber = Replace(PhoneNumber," ","") > > > > > > > > John V. Ruff - The Eternal Optimist :-) > > > > "Commit to the Lord whatever you do, > > and your plans will succeed." Proverbs 16:3 > > > > _____ > > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Jose Luis Mora Jr > Sent: Wednesday, October 12, 2005 10:11 AM > To: AccessDevelopers@yahoogroups.com > Subject: RE: [AccessDevelopers] phone number conversion > > > > The only way that I could think of accomplishing this is by using the > following functions: > > InStr() - this function will find the first occurrence of a dash starting > from the left side in your account number and return a number where the dash > is located. > > InStrRev - this will perform a similar function as InStr but will find the > first occurrence of a dash starting from the right side of the account > number. > > Left() - this function will take the first x characters starting from the > left of the account number. > > Right() - this function will take the first x characters starting from the > right side of the account number. > > Mid() - this function will take a set of characters and somewhere in the > middle of the account number starting at a position you need and then take > the following x character from that location. > > > > You can see what these function do in more detail from the help files. > > > Hope this helps. > > > > Jose > > > > > > > > "When you come to a fork in the road, take it." > > - Yogi Berra > > > > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of teresaamc > Sent: Wednesday, October 12, 2005 12:28 PM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] phone number conversion > > > > I've got a list of account numbers that appear to be formatted with > dashes and spaces between the numbers. I need to convert these numbers > to a format without spaces or dashes. I've tried searching the > messages here and can't come up with any results. Does anyone have a > solution for me? Thanks!!! > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of Service. > > > > _____ > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
