Prev: Keyboard shortcut for Paste Special-Values
Next: Running total based upon current date
From: raju on 10 Apr 2010 06:17
dear sir

in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
please help me.

thanks advance.

raju
From: Jacob Skaria on 10 Apr 2010 06:39
Hi Raju

One way..

In B1
=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1)

In C1
=SUBSTITUTE(A1,B1,)

--
Jacob (MVP - Excel)


"raju" wrote:

> dear sir
>
> in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
> please help me.
>
> thanks advance.
>
> raju
From: Rick Rothstein on 10 Apr 2010 10:12
Give these formulas a try...

B1: =LEFT(A1,LEN(A1)-LEN(C1))

C1: =LOOKUP(9E+307,--RIGHT(A1,ROW($1:$99)))

Note: When you put the first formula into B1, it will initially display the
entire contents of A1 **until** you put the other formula into C1.

--
Rick (MVP - Excel)



"raju" <raju(a)discussions.microsoft.com> wrote in message
news:F75DC9EE-6014-4661-A87B-6C9AB858065B(a)microsoft.com...
> dear sir
>
> in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
> please help me.
>
> thanks advance.
>
> raju

From: Teethless mama on 10 Apr 2010 10:45
In C1: =LOOKUP(10^10,--RIGHT(A1,ROW(1:99)))

In B1: =SUBSTITUTE(A1,C1,)



"raju" wrote:

> dear sir
>
> in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
> please help me.
>
> thanks advance.
>
> raju
From: ozgrid.com on 10 Apr 2010 22:52
Try: http://www.ozgrid.com/VBA/ExtractNum.htm to pull the number into C1,
then: =SUBSTITUTE(A1,C1,"") in B1



--
Regards
Dave Hawley
www.ozgrid.com
"raju" <raju(a)discussions.microsoft.com> wrote in message
news:F75DC9EE-6014-4661-A87B-6C9AB858065B(a)microsoft.com...
> dear sir
>
> in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
> please help me.
>
> thanks advance.
>
> raju

 | 
Pages: 1
Prev: Keyboard shortcut for Paste Special-Values
Next: Running total based upon current date