Need formula or trick to split column

[MohanBabu1023]

Hi,

Kindly find the attached file, in this split A column using formula or tricks.

Regards
Mohan

 

[Sanjeev06]

Normal text to column function you can use,.

 

[bobhc]

Text to columns as per attachment

 

[MohanBabu1023]

I can't able to split using text to column

 

[MohanBabu1023]

Thank u bobhc

i didn't tried with fixed with now its fine.

 

[Tererai Muridzo]

I can't able to split using text to column

hi
1.To get the name use =IFERROR(LEFT(A3,FIND(" ",A3,10))," ")


2.to get email use=IFERROR(RIGHT(A3,25)," ")
3.Stuck on how to get Network ID

see attached file with the respective formulas

Regards

Tererai

 

[MohanBabu1023]

Thank u tererai for your response, it's helpful for me.

 

[AVK]

Are you try with "convert text to columns wizard.
>Firstly select column "A"
>Go to "Data" tab
>click on "Text To Columns"
>select data range as per your data width & in destination mentioned "$C1"