Hi
Plz provide VBA code for extract .rar file.
On Oct 14, 2014 7:23 PM, "Dr. Schwartz" wrote:
> I have a workbook that is opened by many users in different environments.
> My goal is to determine the value of *Application.UseSystemSeparators*
> (True/False) using the Workbook_open() and somehow s
Plz provide VBA code for extract .rar file.
On Oct 14, 2014 7:23 PM, "Dr. Schwartz" wrote:
> I have a workbook that is opened by many users in different environments.
> My goal is to determine the value of *Application.UseSystemSeparators*
> (True/False) using the Workbook_open() and somehow save
Hi Frd,
=max(substitute(cellvalue ya cell reference,"IT","",1))
Try kro bhai
On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote:
> Dear Friends,
>
> Please help me in finding the maximum value in a non numeric column,
> example below
>
> Answer needed is IT20140010
>
>
> IT20140001 IT20140002 IT2
