Sir,
when i browse not showing .csv files & excel worksheet
thank you
On Wed, Mar 11, 2015 at 11:59 PM, Bé Trần Văn
wrote:
> Try using the Merge File.
>
> See instructions in File.
>
> 2015-03-11 20:02 GMT+07:00 :
>
>> Sir,
>>
>> i need a macro to import multiple file to single file
>> i got so
Very Nice... Mr.Vabz
On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote:
> Suppose you have value in cell A1 then type follo. formula in A2 & dont
> press enter & press F9, you will get result in curly bracket, after = sign
> enter CONCATENATE( & press enter to get result
>
>
> =T
Suppose you have value in cell A1 then type follo. formula in A2 & dont
press enter & press F9, you will get result in curly bracket, after = sign
enter CONCATENATE( & press enter to get result
=TRANSPOSE(IF(EXACT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),
Try hyperlink. It can direct you to objects saved on hard drive.
W dniu środa, 25 lutego 2015 17:41:47 UTC+1 użytkownik Bill Q napisał:
>
> Hi,
>
> I can do this as an object - but quite frankly it is more hassle than what
> it's worth.
>
> Does anyone have a better way (with minimal steps) wher
I did not found any method, however you can use Macro to achieve the same..
On Tue, Mar 3, 2015 at 10:21 PM, Bill Q wrote:
> Anyone ?
>
>
> On Wednesday, 25 February 2015 11:41:47 UTC-5, Bill Q wrote:
>>
>> Hi,
>>
>> I can do this as an object - but quite frankly it is more hassle than
>> what i
Use Data==> Filter to get non zero values...
On Wed, Mar 11, 2015 at 1:34 PM, Harish P Y wrote:
> Hi,
>
> Needed help with the file attached file.I want to get the data of only the
> non zero elements from abstract sheet to abstract 2 sheet.
> kindly help me in this regard. tried pivot table but