| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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_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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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_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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 - Macro for splitting text and then replacing something | Excel Discussion (Misc queries) | |||
| Macro Assistance (Splitting into new workbook by value) | Excel Discussion (Misc queries) | |||
| splitting cell text using macro | Excel Discussion (Misc queries) | |||
| Splitting a Cell | Excel Worksheet Functions | |||
| Splitting text in cell with Excel 97 VBA macro | Excel Programming | |||
Linear Mode
