Macro to split table cells

macropod · #1 03-07-2016, 11:36 PM

Although there are two tables in your document, neither of them appears to show how what you apparently want the first one reformatted.

nachiketapte · #2 03-08-2016, 12:02 AM

Quote:

Originally Posted by macropod

Although there are two tables in your document, neither of them appears to show how what you apparently want the first one reformatted.

I don't understand where the confusion. Just focus on the first table. The first row of the table has 3 columns. Sr. # , Drawings, Drawing Type. I have values as 1, Drawing 4, Drawing 27 and EC,C in the first row. My goal is to have values similar to this

1 Drawing4 EC
2 Drawing27 C

I hope I have made myself clear

macropod · #3 03-08-2016, 12:13 AM

Quote:

Originally Posted by nachiketapte

I don't understand where the confusion. Just focus on the first table. The first row of the table has 3 columns. Sr. # , Drawings, Drawing Type. I have values as 1, Drawing 4, Drawing 27 and EC,C in the first row. My goal is to have values similar to this

1 Drawing4 EC
2 Drawing27 C

I hope I have made myself clear

Well, if you look at your first post, I doubt even you could discern the required structure from that...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
split row of cells at semicolon	lbeck	Excel	8	06-06-2015 01:55 PM
how to split merged data into vertical saperate cells	cheekugreat	Excel	5	10-11-2014 05:53 AM
Macro to loop through all cells in a table produced by a mail merge	elh52	Word VBA	4	08-31-2014 10:50 PM
Losing rows when pasting split cells	Gitley	Word Tables	1	01-15-2013 07:49 AM
Macro to Merge Cells Row By Row in a Table	KD999	Word VBA	4	02-20-2012 08:51 PM