split

[soumyajit]

how dose i split the bellow mention text from;

A1

hbbj-54564-bhjbj-65666


to;


A1 B1 C1 D1

hbbj 54564 bhjbj 65666


with a formula (with out using rext to columns.

 

[Hui]

Select A1

Goto Data tab

Text To columns

Delimited

Other, enter a -

Apply

 

[Debraj]

Hi Soumyajit..


Please read below..


http://chandoo.org/forums/topic/date-3#post-85061


then Read below too...

http://chandoo.org/forums/topic/need-predefined-formula-for-text-to-column#post-32161

http://chandoo.org/forums/topic/help-breaking-data-within-a-cell-into-separate-components#post-43907


Regards,

Deb

 

[Hui]

or using formulas

A2: =LEFT(A1,FIND("-",A1)-1)

B2: =MID(A1,FIND("-",A1)+1,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1,1)-1)

C2: =MID(A1,FIND("-",A1)+LEN(B2)+2,FIND("-",A1,FIND("-",A1)+1)-FIND("-",A1,1)-1)

D2: =RIGHT(A1,LEN(A1)-(LEN(B2)+LEN(C2)+FIND("-",A1)+2))