formula excel help

I have several thousand entries that I need to modify. I need to swap 1st and 2nd digits with 5th and 6th digits. The following is an example of current and desired. Example: 012923123456654321 would be changed to 232901123456654321 I cannot figure out the formula to get this done. Any...

Hello, Does anyone know how to add the unit (such as $ or pounds) on top of the y-axis in the line chart? I could only find the way to add the currency to all numbers on the y-axis but I want it to show $m on top of the y-axis only. Thanks in advance.

Hi Guys, Need your help to build a formula for below slab-table wherein comparing values from Slab range ,Penalty % and Slab base. Condition is Slab range must achieve slab base to get lower penalty Decrease Slab Base Slab Range Penalty % Below 30 0-30 0.0% 30 30.01-44.99 1.0%...

Hi guys, I am working on a formula to show what the late fee needs to be depending on date rent was paid. I go a formula to do that, but i am struggling to get a 60 dollar value for a "no pay" of rent. below is a preview of my formula. I cant get it to populate when i place text in the cell...

Hi there, I really hope someone can help me, this job normally takes a whole day of mundane data entry to complete. This needs to be done twice a month so if I can do this with excel you will save me 3 weeks of boring work. A product represented by an 'S Code' in Column A (see below) needs...