thanks guys... i did'nt know that function...

Kind Regards
Brian

"Stefi" wrote:

Use Data-Text to columns, separated option, and give : in other separator!
Regards,
Stefi


€žBrian Brandt€� ezt Ã*rta:

Hi
I would like to split a cell, using the sign ":" as the one that defines
where to split it...

ex.
Vil_du_træne_hjemme_for_at_nå_dit_mål?: 'Ja'
Vil_du_gå_i_motionscenter_for_at_nå_dit_mål?: 'Ja'
Vil_du_ændre_dine_spisevaner_for_at_nå_dit_mål? : 'Ja'

becomes
Vil_du_træne_hjemme_for_at_nå_dit_mål?: -new cell 'Ja'
Vil_du_gå_i_motionscenter_for_at_nå_dit_mål?: -new cell 'Ja'
Vil_du_ændre_dine_spisevaner_for_at_nå_dit_mål? : new cell 'Ja'


Is that possible... ??

Kind Regards
Brian Brandt