Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
Function RemoveAlpha(cellInput) As String Set cellInput = Intersect(cellInput.Parent.UsedRange, cellInput) For i = 1 To Len(cellInput) Select Case Mid(cellInput, i, 1) Case 1, 2, 3, 4, 5, 6, 7, 8, 9, 0, " ", "-", "/" ,"@" ,"%" Charval = Mid(cellInput, i, 1) Case Else Charval = "" End Select RemoveAlpha = RemoveAlpha & Charval Next i End Function
|Find reord based on ID, specific date of service in a range and specific comment. If match then indicate in master file yes or no||12||25|
|Excel calculate based on 'x' in column||2||25|
|hi all how do i achive this formula in condtional formatting excel||6||18|
|How to make data for pivot table open and add to original sheet with the named sheet||16||29|