+ Reply to Thread
Results 1 to 5 of 5

Macro for splitting a cell

  1. #1
    Brian Brandt
    Guest

    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_trne_hjemme_for_at_n_dit_ml?: 'Ja'
    Vil_du_g_i_motionscenter_for_at_n_dit_ml?: 'Ja'
    Vil_du_ndre_dine_spisevaner_for_at_n_dit_ml?: 'Ja'

    becomes
    Vil_du_trne_hjemme_for_at_n_dit_ml?: -new cell>> 'Ja'
    Vil_du_g_i_motionscenter_for_at_n_dit_ml?: -new cell>> 'Ja'
    Vil_du_ndre_dine_spisevaner_for_at_n_dit_ml?: new cell>> 'Ja'


    Is that possible... ??

    Kind Regards
    Brian Brandt

  2. #2
    Jeff Standen
    Guest

    Re: Macro for splitting a cell

    Easies way is to use Data> Text to columns, and use the semicolon as the
    delimiter.

    Jeff

    "Brian Brandt" <[email protected]> wrote in message
    news:[email protected]...
    > Hi
    > I would like to split a cell, using the sign ":" as the one that defines
    > where to split it...
    >
    > ex.
    > Vil_du_trne_hjemme_for_at_n_dit_ml?: 'Ja'
    > Vil_du_g_i_motionscenter_for_at_n_dit_ml?: 'Ja'
    > Vil_du_ndre_dine_spisevaner_for_at_n_dit_ml?: 'Ja'
    >
    > becomes
    > Vil_du_trne_hjemme_for_at_n_dit_ml?: -new cell>> 'Ja'
    > Vil_du_g_i_motionscenter_for_at_n_dit_ml?: -new cell>> 'Ja'
    > Vil_du_ndre_dine_spisevaner_for_at_n_dit_ml?: new cell>> 'Ja'
    >
    >
    > Is that possible... ??
    >
    > Kind Regards
    > Brian Brandt




  3. #3
    Stefi
    Guest

    RE: 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


  4. #4
    Jeff Standen
    Guest

    Re: Macro for splitting a cell

    I mean the colon of course.

    Jeff

    "Jeff Standen" <[email protected]> wrote in message
    news:[email protected]...
    > Easies way is to use Data> Text to columns, and use the semicolon as the
    > delimiter.
    >
    > Jeff
    >
    > "Brian Brandt" <[email protected]> wrote in message
    > news:[email protected]...
    >> Hi
    >> I would like to split a cell, using the sign ":" as the one that defines
    >> where to split it...
    >>
    >> ex.
    >> Vil_du_trne_hjemme_for_at_n_dit_ml?: 'Ja'
    >> Vil_du_g_i_motionscenter_for_at_n_dit_ml?: 'Ja'
    >> Vil_du_ndre_dine_spisevaner_for_at_n_dit_ml?: 'Ja'
    >>
    >> becomes
    >> Vil_du_trne_hjemme_for_at_n_dit_ml?: -new cell>> 'Ja'
    >> Vil_du_g_i_motionscenter_for_at_n_dit_ml?: -new cell>> 'Ja'
    >> Vil_du_ndre_dine_spisevaner_for_at_n_dit_ml?: new cell>> 'Ja'
    >>
    >>
    >> Is that possible... ??
    >>
    >> Kind Regards
    >> Brian Brandt

    >
    >




  5. #5
    Brian Brandt
    Guest

    RE: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1