ExcelBanter - how to change (555)123-1234 to 5551231234

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to change (555)123-1234 to 5551231234 (https://www.excelbanter.com/excel-discussion-misc-queries/69272-re-how-change-555-123-1234-5551231234-a.html)

JMB

how to change (555)123-1234 to 5551231234

If your data is in cell A1, enter this in B1 and copy down, then you could
copy/paste special values.

=--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","" ),"-","")

"buccig" wrote:

i want to convert telephone number to regular number

All times are GMT +1. The time now is 12:02 PM.