Re: Extracting Every Other Digit
Try:
=MID(A2,1,1)+MID(A2,3,1), etc.
Re: Extracting Every Other Digit
Try:
=MID(A2,1,1)+MID(A2,3,1), etc.
Re: Disable save and save as
You might use a template and save it as read only.
Re: macros or function
Try:
=LEFT(A2,3)&"-"&RIGHT(A2,6)
Re: Time Calculation
Try:
=MOD(F5-E5 ,1)
Re: How to get the code in the middle?
Try:
=MID(A2,FIND("-",A2)+1,7)
Re: Commission Spreadsheet
Check this out:
http://www.mcgimpsey.com/excel/variablerate.html
Re: Removing a dash from a number....
Try Find and Replace
Re: Extracting two words out of a cell
Try this:
=IF(A1="Alpha","Alpha","Alpha Beta")
Re: Suppressing blank cells in data validation list
Perhaps something like this:
Private Sub Worksheet_Activate()
Dim r As Range, txt As String
For Each r In Range("A1", Range("A" & Rows.Count).End(xlUp))
If Not IsEmpty(r) Then txt = txt & "," & r.Value
Next
With Range("C1")
.Value = Empty
With .Validation
.Delete
.Add Type:=xlValidateList, Formula1:=Mid$(txt, 2)
End With
.Select
End With
End Sub
Display More
Re: Insert Row When Text Changes
Change "A" to "T", like this:
Re: decimal to time conversions for payroll
Try:
65:48*24=65.80 Cell format: Number
65.80/24=65:48 Cell format: [h]:mm
Re: Sorting Data (Numbers) Within a Single Cell
Another one:
http://www.mrexcel.com/forum/showthread.php?t=367994
Function OrderCell(sStr As String)
Dim i As Long, ii As Long, a()
ReDim a(1 To Len(sStr))
For i = 1 To Len(sStr))
a(i) = Mid$(sStr, i, 1)
Next
For i = 1 To UBound(a) - 1
For ii = i + 1 To UBound(a)
If a(i) > a(ii) Then
temp = a(ii) : a(ii) = a(i) : a(i) = temp
End If
Next
Next
OrderCell = Join(a, "")
End Function
Display More
Re: capital first letter for new sentence
Take a look here:
http://www.mrexcel.com/forum/showthread.php?t=356800
Re: Change image based on combo box selection
Here is an explained example:
http://www.freewebs.com/davesexcel/SelectPicGetPrice.xls
Re: Change image based on combo box selection
Maybe this:
http://www.excelforum.com/excel-general/…own-link-2.html
Re: Copy row(s) of data from one worksheet to another based on column criteria
Perhaps one of these examples will suit:
http://www.contextures.com/excelfiles.html#Filter