Segregate Data

[neeraj2050]

Greetings!!

Into cell B2 “KSJ 2K”, cell B3“PKSA 1KA “ is mentioned

I want to segregate data into two columns i.e before space and after space

Into in Cell C2 "KSJ", cell D2 "2K"

I cannot use Text to column and nor looking for VBA solution

Regards
Neeraj Kumar Agarwal

 

[Hui]

C2: =LEFT(B2,FIND(" ",B2)-1)
D2: =RIGHT(B2,LEN(B2)-FIND(" ",B2))

copy both down

 

[rahulshewale1]

hii @neeraj2050

another option

try below formula

Coulumn 1 :cell C2 =LEFT(B2,FIND(" ",B2)-1)
Coulumn 1 :cell D2=MID(B2,FIND(" ",B2)+1,10000)


Text to Column :

Select Column B (data ) >> Go to data tab >> Text to column
>>Select Delimited >> Uncheck tab >> tick mark to Space >> Next >>Desitination >> C2 >> Finish .





Regard
Rahul shewale

 

[Syedali]

My try....

 

[neeraj2050]

Thanks everybody for your time and valuable suggestion!!

@Hui Sir: (" ",B2)-1)
Why we have used -1 into this. Would you mind to brief about it

Thanks in advance!!

Regards
Neeraj Kumar Agarwal

 

[Syedali]

KSJ 2K =FIND(" ",B6)-1

Find will find the position of character....

1.To find space in which position and it is in 4th position
2. After that we need cell value before space , Hence he putted "-1"

After that using left formula he defined it...
=LEFT(B2,FIND(" ",B2)-1)

I hope you will understand this.....