Telephone column

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:57 PM GMT

Question

Hi Ken, This was seems like it should be simple... I have a telephone column, in which values are mixed from (910) 334-4567, to 2125551212; I would like them all to come out solely digits - i.e. 9103344567, how can I do this? thanks,Monte

Answer

Monte Do a search and replace on the column to replace all the ( with nothing, then the ) with nothing, then the - with nothing. Then format the column with a custom format to make them all look like phone numbers. It is possible that they won't be recognized byas numbers after the replacements, in which case you will just have to multiply the column by 1. Then they will be recognized as numbers, and custom formats will work.

Advertisement

©2021 eLuminary LLC. All rights reserved.