I mean the colon of course.

Jeff

"Jeff Standen" wrote in message
...
Easies way is to use Data Text to columns, and use the semicolon as the
delimiter.

Jeff

"Brian Brandt" wrote in message
...
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