substitute formula

Using Excel 2013: I have a spreadsheet with values in this format. ="10/26" This is not a calculated value. That is how it extracted from another database. I have over 100,000 values in this format so doing them individually not realistic. I need a formula or process to extract only the...

Hey there, I'm combining 2 different Excel Templates to make a budget, where one sheet is a yearly summary, and the rest are monthly budgets. Each monthly sheet contains tables with the general name tblMONTHCategory, where MONTH is the first 3 letters of that month, and Category are the budget...

Hi guys. Is there a formula here to replace sequencially all characters of a given value by a specific character? Let me show you. I have this value : google.com need to replace one character after one character by the "*" symbol. So it will give me this : *oogle.com g*ogle.com go*gle.com...

Good day Demigods, Sheet 1, cell A1 contains alphanumeric user entered data and is referenced on ten other sheets. Some users enter data as , Others enter data as, for example, - curse them! I'm not bothered how it looks on Sheet 1, cell A1, but for the other worksheets, I want the data the...

Dear friends, How do i add forward slash (/) between first word and numeric value. For eg. AFRAM/101; AES/151 <TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=603><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt...

I have the following in cell A1: optimized-by.rubiconproject.com/a/8191/13252 I need to remove everything from the left of the second decimal from the right...

Hi, Background: I have been visiting mrexcel forum for improving my formula writing skills. And this forum and the guys on this forum are absolutely fantastic . Apart from this, I have a small group of office-mates who are like minded in this endeavor. Any one of us creates an academic problem...