partial contents

Dear all, I have a column in which i have a data in the following format: Name%datetime e.g: John%2018/03/08 19:50 Davis%2018/03/08 19:58 Dawson%2018/03/08 20:05 Now i want to extract just names from these above strings and want to delete the %datetime. Please let me know how i can do this...

Hi All Really need some help or guidance. From a report listing 2000 groups and Manager I need to compare names in each column. Column C would have the result (Match/No match) Obviously column A is a match, column B isn't) Column A company.co.uk/Accounts/Users/Bill Smith...

Hi All I have cobbled together the code below to try and clean up some data. The code seems to identify the correct values but returns very strange and inconsistent results. What I am trying to do, is look down Col W and any cell that contains "VIN#" delete the "VIN#" and 9 characters to the...

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim c As Range If Target.Cells.Count > 1 Then Exit Sub Set c = Intersect(Range("C14:C28"), Target) If c Is Nothing Then Exit Sub Cells(Target.Row, 1).Resize(, 5) = "" Target = "X" End Sub I had seen this on a previous post in...

I am trying to somewhat use a "left" function but the number of characters I am needing to extract will vary. Here is what my data looks like. (Each line is one cell.) #300 2007 Freightliner #66471 2008 International #4540 2009 International I am needing to separate the unit numbers and...