View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] malyjohn@hotmail.com is offline
external usenet poster
 
Posts: 3
Default Inserting columns in rows with some text

Hello!
I have a following problem. I have in Word a table with following rows:

John
180cm 65kg 20/17 ws
Mike
178cm 75kg 30/15 ns
198753 198765 123 qd
Kevin
no data
Tom
173cm 73kg 40/18 es
....

I would like to insert columns in some of rows to get something like
that

John
180cm | 65kg | 20/17 | ws
Mike
178cm | 75kg | 30/15 | ns
198753 | 198765 | 123 | qd
Kevin
no data
Tom
173cm | 73kg | 40/18 | es
....
My table counts more than thousand rows so this makes way "by hand"
useless.
Is there any way in VBA to achieve that?
Thank you in advance
John Maly