Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-11-2018, 05:13 AM
Ktulu Ktulu is offline Split column at a particular character Windows 7 32bit Split column at a particular character Office 2007
Novice
Split column at a particular character
 
Join Date: Apr 2018
Posts: 6
Ktulu is on a distinguished road
Default

Quote:
Originally Posted by slaycock View Post
Yes. Convert the whole table to text. Then convert text to table using '|' as the character that marks columns.
Thank you, Slay. Some rows separated with - and the table is pretty complicated to convert. So I am manually entering the data in a new table.

I would greatly appreciate if you could help me with one more problem.
There is one table in the document. Each page has 62 rows and the table continues.
I made a macro to hide top, left and right borders of the first row and bottom, left and right borders of the last row of the page.

How to put this macro in a loop which would repeat for total number of pages?
How do I assign value of total number of pages to an integer?
Thanks again!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Perform function when t-character is entered in Column-A SerenityNetworks Excel Programming 3 12-22-2017 09:24 AM
Split function in Excel (split the screen) Officer_Bierschnitt Excel 1 07-05-2017 07:02 AM
Detecting that previous character doesn't exist (i.e., present character is first in document) Robert K S Word VBA 15 08-01-2016 09:33 AM
how can i split a column of rows in half without copy and paste.. Lindseyfparker Excel 2 04-25-2014 12:52 AM
Split one column to several columns moishy Excel Programming 1 02-01-2013 12:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft