Break 5 items in single excel cell to multiple cell

May 17, 2012 at 20:14:19
Specs: Windows XP
Hi, i have this excel data table

Date Application No. Calls Type
1/25/2012 Login 36 Login
Call Back 21 PC Software
Business Apps 32 PC Software
Apps 49 Printer
Outlook 13 Firecall


These all are cell A1,B1,C1,D1, though it looks messed up there but all application,calls and types are below eachother and date in first cell , i have to break it into multiple cell such as for each 5 same date 1/25/2012 on one row will have corresponding data.
eg.
1/25/2012 Login 36 login
1/25/2012 Business App 32 PCSoftware

I know i have to use VBA but don't have idea please help me.


See More: Break 5 items in single excel cell to multiple cell

Report •


#1
May 18, 2012 at 04:59:16
i am slightly confused with you question, it kind of doesnt make sense to me, maybe im being stupid.

can you clarify:

where does the below data sit? in one cell or multiple cells?

Date Application No. Calls Type
1/25/2012 Login 36 Login
Call Back 21 PC Software
Business Apps 32 PC Software
Apps 49 Printer
Outlook 13 Firecall

Do you just want to split this data into seperate cells? if so then i'd assume the entire data is in one cell, right?

please explain and i can try help you with the vba.


Report •

#2
May 18, 2012 at 06:57:05
sorry actually its different cells and like this
......A1................B1......................C1.......................D1
1/25/2012 ........Login ...................36 ....................Login
Call Back.............. .21.................PC Software
Business Apps .....32 ................PC Software
Apps ....................49 .................Printer
Outlook.................... 13 .................Firecall
its 4 different cells and i have to break it such there will be 4 more cells under cell and fill up data like this.......
A1......................B1....................... ... ..C1...................D1
1/25/2012 .........Login................... 36 ...............Login
1/25/2012 .........Business Apps ...................32 ...............Login
and continue like this

Report •

#3
May 18, 2012 at 07:02:05
So, what you want to achieve is to join

A1 and B1 ans C1 and D1?

if so, then where do you want this new string to appear?

for example

......A1................B1......................C1.......................D1
1/25/2012 ........Login ...................36 ....................Login


E1 = 1/25/2012 Login 36 Login????

is this what you are looking for?


Report •

Related Solutions

#4
May 18, 2012 at 07:16:13

Sorry this text box is not that good merges all text and make difficult to understand ...actually i want cells to be these but filled with above data....A cells will be fill with same date but others will be corresponding column items..
A1..........B1.........C1.......D1
A2........B2........C2..........D2
A3........B3.........C3.........D3
A4........B4..........C4........D4
A5.........B5.........C5.........D5
I hope u undertand this time and thanks a lot for ur response...If you want xsl file i can send you on ur email.
Thanks once again.

Report •

#5
Report •

#6
May 18, 2012 at 16:13:50
How will Text To Columns produce the output the OP wants?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#7
May 18, 2012 at 16:16:58
Tilvil:

Please click on the following and read the instructions on how to post Excel data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#8
May 19, 2012 at 03:49:14
Because whenever I have text in Excel that I want to break up, I use Text to Columns. That seems to be its intended purpose.

How To Ask Questions The Smart Way


Report •

#9
May 19, 2012 at 06:22:56
Read the rest of his posts. The task does not seem to be the type of "breakup" normally associated with Text To Columns.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question