Replies

Do you want to sort Cols A, C, & M as a group and leave the others unsorted? If so I suggest you select Col C and hold down Shift whilst dragging it left to between Cols A & B, this will put it in new Col B and move existing Col B right. Repeat for Col M and drag it to Col C position. You will now have the columns you want to sort in Cols A, B, & C. Select the data in these columns and you should be able to sort it. XL will say you have data next to the selected data, do you want to Expand the selection or Continue with the current selection, choose the latter.

I read somewhere that putting a ‘dead’ hard drive in the freezer for a while will sometimes do a Lazarus on it long enough to recover the data. Don’t know anyone who has tried it though, but it seems reasonably risk-free.

I read somewhere that putting a ‘dead’ hard drive in the freezer for a while will sometimes do a Lazarus on it long enough to recover the data. Don’t know anyone who has tried it though, but it seems reasonably risk-free.

This works for me in XL2000:

=IF(VLOOKUP($A3,$A$1:$D$3,3,FALSE)=””,””,VLOOKUP($A3,$A$1:$D$3,3,FALSE))

This works for me in XL2000:

=IF(VLOOKUP($A3,$A$1:$D$3,3,FALSE)=””,””,VLOOKUP($A3,$A$1:$D$3,3,FALSE))

Excellent.

Thank you.

Excellent.

Thank you.

Yes that’s good. I’ve never had a problem with the speed of my macro, although I don’t use it very often. I do remember it was a bit of a pain to write as Proper isn’t (or wasn’t at the time) a VBA function. Your way is much neater.

Yes that’s good. I’ve never had a problem with the speed of my macro, although I don’t use it very often. I do remember it was a bit of a pain to write as Proper isn’t (or wasn’t at the time) a VBA function. Your way is much neater.

I guess it depends on how many columns you have to deal with, I always use the way I described as it doesn’t involve writing and deleting a 1 to and from the sheet and it seems quicker, at least for a few columns. I seem to remember that someone, maybe Hans or Jan, wrote a macro that multiplied each cell in the selection by 1 to achieve the same result, but I don’t have a copy of it, and without the search function…..

I guess it depends on how many columns you have to deal with, I always use the way I described as it doesn’t involve writing and deleting a 1 to and from the sheet and it seems quicker, at least for a few columns. I seem to remember that someone, maybe Hans or Jan, wrote a macro that multiplied each cell in the selection by 1 to achieve the same result, but I don’t have a copy of it, and without the search function…..

This macro does what you want, select the text you want to convert then run the macro.

Sub Proper()

For Each cel In Selection
gg = cel.Value
cel.Value = “=Proper(“”” & gg & “””)”
Next cel
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False

End Sub

This macro does what you want, select the text you want to convert then run the macro.

Sub Proper()

For Each cel In Selection
gg = cel.Value
cel.Value = “=Proper(“”” & gg & “””)”
Next cel
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False

End Sub

Another way is to select each column in turn, Data Menu, Text to Columns, Finish.

Another way is to select each column in turn, Data Menu, Text to Columns, Finish.