Thank you, Jayaraju.M! Your code works great! Thank you again, I
appreciate you help.
The Best,
MikeB
On Sunday, July 26, 2015 at 3:09:44 AM UTC-5, Jayaraju Metta wrote:
>
> Hi Mike,
> Below is the code to find string and paste it into desired cell.
> Please find the attached excel file.
>
> 'C
Hi Mike,
Below is the code to find string and paste it into desired cell.
Please find the attached excel file.
'Code was written by Jayaraju Metta
Sub matchsting()
i = 1
While (ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value <> "")
ColoumnAstring = Left(Trim(Sheets("Sheet1").Cells(i, 1).Value), 5
I would appreciate any help with the following. I have a column "A" of
data containing shortened names in sheet 1 and another column "C"
containing the same names but in a much longer version on sheet 4; I was
thinking that perhaps I could somehow use the first five characters of the
short
