Macro for splitting a cell
 

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

Macro for splitting a cell
 

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

Macro for splitting a cell
 

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

Macro for splitting a cell
 

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

Macro for splitting a cell
 

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