[rraymond]

I need only pull the last 5 digits of a phone number. The format is ###/###-####. I need to pull the last 5 digits in the following format #####. What function will give me the results I need?

[Rockn]

Which digits are you trying to get out of the phone number, the first four, second four or the middle four?

[rraymond]

Originally Posted by Rockn

Which digits are you trying to get out of the phone number, the first four, second four or the middle four?

I need to pull the last 5 digits in the following format #####. What function will give me the results I need?

[coachdan32]

Take a look at the TRIM function.

[Rockn]

I don't think trim will work as it only takes off trailing or leading spaces. CR is a different creature with it's own screwey syntax. I will look at CR when I get a chance.

[Rockn]

Sorry it took so long to get back. Here is an easy way to do it. You need to create a formula like this:

Right(Replace({PhoneNumber},"-", ""),5)

[rraymond]

Thanks everyone for your suggestions.

Unfornuately the formula Right(Replace({PhoneNumber},"-", ""),5) doesn't work because the command requires that the input field be numeric. I am receiving an error 'Formula result must be numeric'. Any other suggestions?

[Rockn]

Do you have your phone number field set to text? If so put a ToText in front of everything above^^ ToText(Right(Replace({PhoneNumber},"-", ""),5))