sandbox

This Excel Macro should help. Change the values in 'Range("K3:K140").Select' to suit your columns. You may also need to change sheet name from 'Sheet1' to match your sheet name. A quick google will show you how to use macros. Sub SortMC() Dim sTmp As String Range("K3:K140").Select 'Find Mc For Each cell In Selection sTmp = Mid(cell.Value, 1, 2) If sTmp = "Mc" Then cell.Value = Left(cell.Value, 1) & " " & Mid(cell.Value, 2, 50) End If Next 'Find Mac For Each cell In Selection sTmp = Mid(cell.Value, 1, 3) If sTmp = "Mac" Then cell.Value = Left(cell.Value, 2) & " " & Mid(cell.Value, 3, 50) End If Next 'Sort ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("K3"), _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal With ActiveWorkbook.Worksheets("Sheet1").Sort .SetRange Range("K3:K24") .Header = xlGuess .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With For Each cell In Selection sTmp = Mid(cell.Value, 1, 2) If sTmp = "M " Then cell.Value = Left(cell.Value, 1) & Mid(cell.Value, 3, 50) End If Next For Each cell In Selection sTmp = Mid(cell.Value, 1, 3) If sTmp = "Ma " Then cell.Value = Left(cell.Value, 2) & Mid(cell.Value, 4, 50) End If Next End Sub

Does this help? https://docs.google.com/document/d/1l5Tj9xpiwsDlmnWxDdhJ9RlkJHaLHiMux7lNIUKWaxE/edit

For the volume button, your remote might be faulty. Try this app https://play.google.com/store/apps/details?id=com.panasonic.pavc.viera.vieraremote2&gl=GB

Cheers for all the replies, it looks like I'm going to add it my collection of things to save 'Just In Case' I need it one day.

It's a lot smaller than it looks, and not strong enough to be a chisel, though it may be something to do with a drill. A better picture showing size here Pic

Does anyone know what this is. Sorting garage out and I found this. Not sure what it is, but daren't throw it out just in case. Image

Try this. With the Ext. hard drive plugged in go to Control Panel>All Control Panel Items>Administrative Tools and open 'Computer Management'. Go to Storage>Disk Management and right click the relevant disk and change drive letter. Hope this helps

Cheers for all the replies. Hours of hassle and frustration avoided, and I now know what a push-fit is 😋.

I am trying to replace a faulty Washing Machine Valve, but am struggling to remove. It is very tight, possibly seized (Arrow A in pic). Just above it is a plastic fitting (arrow B in pic). Is this plastic fitting push-in or screw off and would I be better removing this and then tackling the valve, or just keep trying to unscrew the valve(A). The actual washing machine hose has already been removed even though it is shown connected. Thank you

Cheers Ghozer, not experienced these problems personally, only what I've read. Might have to give Win 10 another try

A while since I used Win 10, but Win 7 meets my needs, I know and understand it. I think what planted the upgrade seed is all the horror stories I read about unwanted updates, files deleted, peripherals stopped working etc. etc.

I have briefly used Win 10 before reverting back. I didn't like it, plus all the horror stories I keep reading. My current system is Intel i7 860 © 2.80GHz 2.80 GHz 8.00 GB Ram 64-bit Operating System

I have an 8 year old PC running Windows 7. I don't have any issues, and I'm happy with the performance and speed. What is the expected life span of the motherboard/processor? I DO NOT want to move to Windows 10, and worried that if it breaks in the future I would have to get a Win 10 machine, so I am thinking of upgrading to this - https://www.palicomp.co.uk/intel-skylake-core-i3-6100-z170-p-cpu-motherboard-bundle, while still available, £250 with RAM etc. This is the last generation that runs Win 7 and would be a precautionary future proofing just so I can keep Win 7. Should I make the upgrade, or is there plenty of life in my current machine?

In windows explorer, go to the top folder and search for *.mp3, then move/copy the results

Hi Yorkiepudd, who did you end up going with?