hit "CTRL + SHIFT + ~"KEY...
Regards,
Viral Pandya
On Fri, Feb 26, 2010 at 2:53 PM, ankur wrote:
> format the cells of whole sheet in general format...
>
>
> if still problem
> check this link
> http://www.brighthub.com/computing/windows-platform/articles/2
Say Cell A1 is 12 Roosevelt Ave
=VALUE(LEFT(A1,FIND(" ",A1,1)))
Regards,
Viral Pandya
On Thu, Feb 25, 2010 at 8:23 AM, Mike wrote:
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another cell. For example:
&g
Dear Excel Champs...,
Please help me out, I want to password for an XLA (add-ins) file.
Is there any way to know the coding of an XLA file???
awaiting reply.
Viral Pandy
--~--~-~--~~~---~--~~
--
Dear All,
Just FYI. this question is closed.
How ever we shud start a tredition that as soon as some1's query resolved,
he/she shud reply with a thanking note to the person who so ever have solved
that query...
Hope member will agree and start practice.
Regards,
Viral Pandya
On Thu, F
i have already send file with result wht required.
Regards,
Viral Pandya
On Thu, Feb 12, 2009 at 7:37 AM, SHAH DARSHIL wrote:
> Can any one help on below attached file.
>
>
> can help me for attached file . i want to retain the "." in data .
> i try with your so
How can i open Password protected XLA file?
Regards,
Viral Pandya
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit
find the attached file.
Regards,
Viral Pandya
On Thu, Feb 5, 2009 at 12:41 AM, Sachin N Harale
wrote:
> Dear friends,
>
> Please help me out in filtering the "," (comma) out from the data which is
> comma separated. Further I want to retain the "." (dot) in d
find attached file
Regards,
v...@l p...@ndya
On Wed, Feb 4, 2009 at 3:05 PM, shay shay wrote:
>
> please help me with count function
> --
> Shay
>
> A Thinker tends to use reason and logic
>
> A feeler tends to use values and subjective Judgement.
>
> Be a Thinker in Life.
>
> >
>
--~--~--
Please find attached file.
Regards,
Viral Pandya
+91-992-432-1990
On Tue, Feb 3, 2009 at 8:09 PM, Rabindra Thapa wrote:
>
> Please help me on attach files.
> --
>
> Regards,
> Rabindra Thapa
> ¨`·.·´¨) Always
> `·.¸(¨`·.·´¨) Keep
No need to wrote macro
select column,
press F5
select special
select constants
hit enter...
that's it
Regards,
Viral Pandya
On Sun, Feb 1, 2009 at 9:08 PM, Debasish Sahu wrote:
> Hi I hv a xl sheet whre i want to copy one of the column which contains
> both blank
ALT + E + I + S
On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote:
>
>
> The fill handle is very helpful for filling cells with various values.
> However, I much prefer to use the keyboard in preference to the mouse. Is it
> possible to utilize the fill handle in some way only by using the keyboa
Dear All,
Please find attached file.
My problem is self explanatory if you see the file.
Thanks in an advance.
Regards,
Viral Pandya
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group
Office that's the ultimate solution for your
problem.
Regards,
Viral Pandya
On 1/21/09, vinu wrote:
>
>
> Yes I have tried.. its not working..
>
>
> On Jan 21, 10:51 am, Naveen wrote:
> > Hi,
> > Have u tried this one.?
> >
> >
>
Plz plz plz help me out.
On 1/18/09, VIRAL PANDYA wrote:
>
> Dear All,
>
> I have a excel sheet contains 128 Sheets and daily i have to take print out
> only for 5 Sheet (record sheets).
>
> Is there any way by which i can create a linked excel file for only this 5
Dear All,
I have a excel sheet contains 128 Sheets and daily i have to take print out
only for 5 Sheet (record sheets).
Is there any way by which i can create a linked excel file for only this 5
sheets?
Please help.
Regards,
Viral Pandya
& 12.
Look forward to hear from you soon.
Regards,
Viral Pandya
On 1/6/09, Tom Jeffries wrote:
>
> This may help
>
> To create a link from PowerPoint to the info in your Excel file.
>
> 1. If you're working with content on a worksheet rather than on a
> char
have 24 slides in our MPR presentation.
I workout date in excel and copy the same and paste in Power point as EXCEL
OBJECT.
now i and sheet 1 (say Sales Varience to paste on slide no 2).
Sheet 2 (say receivables date to paste on slide no 3).
Look forward to hear from you soo.
Regards,
Viral
HI DEAR,
I THINK THIS WILL BE EASILY SOLVED WITH USE OF PIVOT TABLE.
WHAT U SAY
REGARDS,
VIR
On 12/29/08, Tom Jeffries wrote:
>
> The attached workbook (GetJobs) shows a way to get the data you want. Use
> the Worksheet_Change event to launch a subroutine to retrieve the desired
> inform
C1 = B1-A1
this will show u result like this 03-01-1900 7:35:00 AM
now go to format cell
go to time on Number Tab select 37:30:55
this will show u ans as *79:35:00*
**
*any query mail me... or call me +919924321990*
**
enjoy...
Regards,
Viral Pandya
I am not programmer, I am just an end-user
19 matches
Mail list logo