000:00:00. Your
solution will work when the data entered as 00:00:00.
Always note that generally the Text Numbers (Values) represent in left side
of the cell and the real numbers stays in the right side of the cell when
there is no specific alignment is defined.
Hope that makes sense :)
---
*
the *Save As* dialog box, save the shared workbook on a network
location where other users can gain access to it.
*To know about sharing and its benefits:-*
http://ezinearticles.com/?Sharing-An-Excel-2003-Workbook&id=1201442
Hope that helps!
---
*Sixthsense
**:) Man of Extreme & In
;-"&--LEFT(TRIM(B2),2)&"-"&--MID(TRIM(B2),5,2))),"")
Herewith I have attached a sample file for your reference.
Hope that helps!
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Thu, May 12, 2011 at 5:44 PM, Prabhu wrote:
> Hi friends,
>
>
Hi Stdev,
Your Solution will fail when the person intended to mention the year 1998 in
this manner 10498.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Fri, May 13, 2011 at 4:13 PM, STDEV(i) wrote:
> *
> =DATE(2000+RIGHT(B2,2),MID(TEXT(B2,"00"
Hi Rajesh,
Find my solution in Column-J of attached excel.
Hope that helps.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Sat, May 14, 2011 at 8:49 PM, Rajesh K R wrote:
> Hi experts,
> pls check the attached file and solve my issue regarding ranking the
> ro
Hi Rajesh,
Find herewith the attachment for deriving result by using single cell
formula.
Guys don't use / suggest helper column / array formula unnecessarily.
Hope that make sense.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Wed, May 11, 2011 at 2:08 AM, R
which is there
in the the cells more than 255 characters won\t get affected.
Hope that helps!!!
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)
*
On Fri, May 27, 2011 at 9:50 AM, Bharghav Ramdas wrote:
> Hi All,
>
> Looking forward to your reponses.
>
> Rgds,
>
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,
ng.
Hope that helps!
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)
*
On Sun, May 29, 2011 at 9:35 AM, Prabhu 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 att
epresented in the right side of the cell
(i.e.) OP expected to derive the Real Number. So I have added the Unary
Operator to convert the Text value as real value.
Hope it’s clear to you!
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Mon, May 30, 2011 at 1:52 AM, hanumant shi
.
=TRIM(MID(SUBSTITUTE("-" & $A2&
REPT("-",6),"-",REPT(CHAR(32),255)),COLUMNS($B$2:B$2)*255,255))
In the above formula I have mentioned the separator as "-" change it based
on your data separator.
I have attached my sample solution file for your ea
In addition Shift+F9 will calculate only the Active Sheet.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Tue, May 31, 2011 at 10:22 AM, Rajan_Verma wrote:
> F9 Only Calculate used Function.
>
>
>
> *From:* excel-macros@googlegroups.com [mai
;))-1),"]",A2,"!B1"),"Click
Here")
or
=HYPERLINK(
CONCATENATE("[",MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1),"
Hi Sukumar,
I am not sure whether this is what you are looking for.. Have a look in the
attached file whether it suits your requirement.
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)*
On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA wrote:
> Hi,
>
> Students English m
14 matches
Mail list logo