trim formula advance

  1. K

    Get rid of leading spaces, Trim and Clean doesn't work, Code shows 0

    Hi gurus, I've read many posts on various forum to solve the problems on the leading space(or space-like stuff), but after trying many functions, including Trim(), Trim(Clean()),Code(Left()), and other ways, I still cannot get rid of it... Originally I pasted these from a word document, and...
    • kangnade
    • Thread
    • trim trim excess spaces trim formula advance trim text work
    • Replies: 16
    • Forum: Excel Questions
  2. P

    Formula to convert (###) ###-#### to ##########

    I am looking for a formula that can convert (###) ###-#### to ##########. Basically I have phone numbers in the common format in column A and want to remove all non-numbers without using a VBA script. Any ideas are welcome. Thanks in advance.
  3. L

    trim formula

    Hi guys, is there a simple formula to convert "67673263-FB10-4231-A60D-4B5354674041_photo-1742912936.jpeg.jpg" into 1742912936? Please help:eeek: Thanks in advance LB

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top