Fomula to Split

**rizmomin** · 02-23-2016, 11:35 AM

Hello:

I have Cell A1 = XYABCDEFG
I need a formula as A2 = XY ABCDEFG
Please let me know if you have any questions.
Thanks.

Riz

**MarvinP** · 02-23-2016, 11:40 AM

Hi Riz,

In A2 put

Please Login or Register  to view this content.

**AlKey** · 02-23-2016, 11:42 AM

Try this

Formula:

Please Login or Register  to view this content.

**Debraj Roy** · 02-23-2016, 11:44 AM

Originally Posted by rizmomin

Please let me know if you have any questions.

Do you have any other condition..

or we need to fetch condition to split..

Formula:

Please Login or Register  to view this content.

**rizmomin** · 02-23-2016, 11:46 AM

Hi GUys:

All solutions are working great.
Thanks a lot
Riz

**rizmomin** · 02-23-2016, 11:48 AM

Hi :

Similarly I have A21 = 2/1/2016
I need A22 = Feb16

Please let me know if you have any questions.
Thanks.

Riz

**MarvinP** · 02-23-2016, 11:53 AM

Hey Riz,

Assuming the thing in A21 is text that looks like a date, try this in A22

=TEXT(DATEVALUE(A21),"MMMYY")

**rizmomin** · 02-23-2016, 11:56 AM

Hello :

I got it working with following

=TEXT(A21,"Mmm")&TEXT(A21,"YY")

Thanks a lot

Riz

**AlKey** · 02-23-2016, 11:56 AM

If you want it as text

Formula:

Please Login or Register  to view this content.

Re: Fomula to Split