Hi Experts,
Need a formula or a code for the sample sheet Attached, this is about the
generating a random based numbers given in spread sheet
Thanks
Prasad
--
--
Some important links for excel users:
1. Follow us
Hi Friends,
I have change my cell which in the date format ex.MMDD or DDMM to
original number i.e smiler to
type date.I have attached the sheet in which Column A shows date format and
Column B is what i need to convert A in to B as a number.
Plz help.
Regards
Prabhu
--
Hi Friends,
I have attached a sheet, which contains space in prefix and suffix.
But below formula is not working.
Kind do the needful.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
HI
What are the changes required to get the result in a cell instead of msg box.
Regards
Rajesh kainikkara
On 5/28/11, GoldenLance samde...@gmail.com wrote:
This is because MAC addresses are attached physically to the network
adapter hardware and not to the base computer itself. Computers
Dear Dew,
Rank is already starting from 1. Please check and revert with some
more details. Thanks.
Best Regards,
DILIPandey
On 5/20/11, dewbro2 kdew...@brownmre.com wrote:
How can I make this rank start with 1 instead of zero.
On Jul 7 2010, 2:41 am, Dilip Pandey dilipan...@gmail.com
=RANDBETWEEN(X,Y) Where X is a number greater than Y Example,
=RANDBETWEEN(1,500) will give random numbers ranging from 1 and 500
On May 29, 7:29 am, Suryaprasad suryaprasad...@gmail.com wrote:
Hi Experts,
Need a formula or a code for the sample sheet Attached, this is about the
generating a
=VALUE(TEXT(A2,MMDD))
On May 29, 9:05 am, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
I have change my cell which in the date format ex.MMDD or DDMM to
original number i.e smiler to
type date.I have attached the sheet in which Column A shows date format and
Column B is
Hi Prabhu
Try
'=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))
http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-beginning-and-end-of-a-cell-HP003056131.aspx
Thanks
Mahesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
I have attached a
Hi
Try
Sub Format()
Dim LR, i As Long
LR = Range(A Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
Range(A i).Offset(0, 1).Value = Range(A i).Value
Range(A i).NumberFormat = mmdd
Range(A i).Offset(0, 1).NumberFormat = mmdd
Next i
End Sub
Thanks
Mahesh
On Sun, May 29, 2011 at
HI Prabhu,
You can use the trim command...
and another solution is that u can use 'Text to columns' action under 'Data'
menu and then take fixed width...
On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
I have attached a sheet, which contains space in
Hi Prabhu,
Try the below formula in cell B2.
=TRIM(SUBSTITUTE(A2,CHAR(160),))
At the same time the same is provided in the attached excel for better
understanding.
Hope that helps!
---
*Sixthsense
**:) Man of Extreme Innovative Thoughts :)
*
On Sun, May 29, 2011 at 9:55 AM, Prabhu
Hi Prabhu,
just convert those dates into below format using below formula.
lets say in col A17 thr is date thn in col B17 type this formula.
=TEXT(A17,mmdd)
A B
5/29/2011 20110529
From: Prabhu prabhugate...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sun, 29 May, 2011 9:35
Hi Prabhu,
Try the below formula in cell B2.
=IF(AND(ISNUMBER(A2),LEN(A2)=5),--TEXT(A2,MMDD),)
Drag the B2 cell formula to the remaining cells of B Column based on the
Column-A data.
At the same time the same is provided in the attached excel for better
understanding.
Hope that helps!
Hi Prabhu,
see if the enclosed file helps
Regards
Umesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
I have attached a sheet, which contains space in prefix and suffix.
But below formula is not working.
Kind do the needful.
--
Hi ,
Thanks for the response. This did solve part of my problem.However when I
split the cell containing more than 255 characters using text to columns
options. I see only the first 255 characters getting split, others are just
ignored. Let me know how I can get away with this issue.
Other
Hi
Using VBA in Excel 2003 is it possible to select a pdf file in a
folder and move it to another folder.
If not, how can I automate this procedure.
Thanks
Paul
--
--
Some important links for excel users:
1.
Hi
try:
For Each objAdapter In colAdapters
Cells(1, 1) = Physical address: objAdapter.MACAddress
Next objAdapter
End Sub
On Sun, May 29, 2011 at 4:46 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:
HI
What are the changes required to get the result in a cell instead of msg
box.
Regards
Hi,
what is the significance of -- just before TEXT in the below formula. this
formula works same even without --.
From: Sixthsense sixthsense...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sun, 29 May, 2011 3:55:33 PM
Subject: Re: $$Excel-Macros$$ How to change Date format in to
can u pls give some light on this coding. i tried to debug but it jus have
sendkey F9.
so if i manually press F9 key in other workbook nothing happens there. can u
explain the logic of this macro.
From: ChilExcel chilexcel...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sun, 29 May, 2011
ThnxRgrdp
SUNIL B.N
-Original Message-
From: PAB
Sent: 29/05/2011 9:36:40 pm
Subject: $$Excel-Macros$$ Moving files from folder to folder
Hi
Using VBA in Excel 2003 is it possible to select a pdf file in a
folder and move it to another folder.
If not, how can I automate this
hai...viewer.
your asking the prombem? how to change landscape to portrait data
ans: just copy all the cells : Go to paste special - transpose
--
--
Some important links for excel users:
1. Follow
Sub Copy_One_File_Only()
FileCopy D:\Bla_Bla_Bla\SOS\SourceFolder\FileName.pdf,
E:\WOW\AngelinaJoly\DestinFolde\FileName.pdf
End Sub
On Sun, May 29, 2011 at 11:06 PM, PAB pab1...@gmail.com wrote:
Hi
Using VBA in Excel 2003 is it possible to select a pdf file in a
folder and move
22 matches
Mail list logo