remove character

  1. A

    How remove the Last 5 character throu VBA

    Hi Folks I need small macros removeing Last 5 character of the Word In Exp: AT_1833 I need AT only. Removring _1833
  2. M

    Removing specific characters from a cell?

    Hi I've got dozens of cells where I need to remove the apostrophe and the '-' in the cell in order to make the data compatible with another system. Eg if the cell A1 had the text Goodfella's Greatest-Ever I'd want to use a formula in B1 that removes the apostrophe and the dash. Does...
  3. O

    Removing a // double slash in a date

    Hi, Back before my time, a program that was written that we no longer have access to the source code wrote dates for some cells with a double slash such as 12//01/2018. I have to go through multiple worksheets in the workbook and manually replace these after the application completes its run...
  4. E

    Remove leading zero from partial string

    Hi, I have a complicated string where I need to remove leading zero from partial string and change the string with different formatting. Example below: <tbody> Original New 02-01-22 [G MM] 2/1/22 3-05-01 [X SM] 3/5/1 07-6-10 [E SM] 7/6/10 </tbody> I have tried using NumberValue but...
  5. G

    How to remove two first and two last characters from a column in Excel with one formula?

    Hello. I have my column A in Excel like this: LT013800 LT025200 PL2011000 PL2061000 LV440200 LV604300 EE440000 EE700000 etc. And I want my column B like this(so I want to remove two first and two last characters from column A using one formula): 0138 0252 20110 20610 4402 6043 4400 7000 etc...
  6. J

    Remove Comma's from Cell

    I have values like this in the cell E6 1177,1178,,,,,1185,,,,,,1344,,,,,,1346,,,,,1251,,,1487,,,,,,1488,,,,,1489,,,,,,1348,,,,,1481,,,,,1485,,,,,,1486 I want these values in separate rows on F column, what should be the formula ?
  7. A

    Extract all Dashes and Upper Case letters

    I have a cells that contain Names and Dashes ex: "Aaron Arbogust -- John SMith -- Bret Johnson -- Dan Bologna" I would like that to extract all Upper case letters and Dashes to read:"AA--JSM--BJ--DB" Basically extract Uppers and Dashes OR remove Lowercase letters and spaces
  8. P

    Excel formula help - remove character from a certain position within a string

    Hi I would like to replace the the last "." with a "0" <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> 1.1.7 1.1.8 1.1.9 1.1.10 1.1.11 </tbody> Much appreciated
  9. S

    Remove symbols, Punctuation marks from list

    Hi Friends, I have a huge list of Names which includes first, middle, last names and along with their titles, education etc., for example Tina DeRubeis van Zyl May Wen-Li Rebecca Hodson, CPA, MST David P. Kraus, Jr. Heather Findon, CPA James C. Lawson, JD, CPA, MST Bruce Feinstein, C.P.A...
  10. K

    stuck on removing specific text

    Hi everyone. I'm trying to remove a specific character ")" however, I need it to fit within my existing formula if at all possible. The formula already identifies "(" and removes the character plus everything left of it. I know that the substitute function is probably best here (either that...
  11. S

    Remove characters before and after, remove zero and add letter

    <colgroup><col span="5"></colgroup><tbody> <colgroup><col span="4"></colgroup><tbody> This is what I have: 000901000017 00068794 0 CA 000901000024 00014544 0 CA 000901000079 00068796 0 CA 000901002004 00050853 0 CA 000901016315...
  12. O

    how to remove "= sign"

    Hi...looking for a formula to remove an "= sign" at the very beginning. hence if "=Jordan" then want to change it to "Jordan" in cell T3 only. but wait, the resulting cell T3 "=Jordan" already has a formula inside it =(U3&V3&W3&X3&Y3) How to enter formula for removing "= sign" and not...

This Week's Hot Topics

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
Top