Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-28-2023, 09:59 PM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Help Please, need script If find column width x value, then Split, except last column Windows 10 Help Please, need script If find column width x value, then Split, except last column Office 2019
Competent Performer
Help Please, need script If find column width x value, then Split, except last column
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 190
Cendrinne is on a distinguished road
Default Help Please, need script If find column width x value, then Split, except last column

Hello Pros,
I'm still in a peek period and I'm fedup of manually splitting up columns of all my tables. I could have 100s.

I've tried many times, creating my own scripts and I get no where or error messages.

Goal :
If a column which has no heading, No Text, only numbers, has a prefered width (Inches to points) of (0.12), then either put it as (0.24) then double it (if possible except the last column) or else it's ok, I will just not select it when copy and paste.

Or If a column has a symbol of $:% alone in its own column, then (it's already put at a width of (0.12), do the same thing as above [put it as 0.24 then split in two].

Anyway which is easier.

Reason: Some of my documents has a gap after the symbols $% which are in a separate column (Helped by Greg Maxey to double my Amount Columns and Move the symbols $% to an empty columns, which I'm so grateful for the helped).

Now I seem to need an extra empty column besides the symbols columns [$%].



I'm truly trying and getting nowwhere

Any help I would be so ever grateful

If it's not doable, please let me know as well, so I won't waste my time trying.

C
Reply With Quote
Reply

Tags
help please, if column width then



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to check combinations of values in one column to find match from another column kong1802 Excel 1 06-15-2018 05:26 AM
find chart column(bar) width. ankitabagul18 PowerPoint 0 12-21-2016 09:44 PM
Column Width keeps changing alsmith Word Tables 1 05-25-2013 02:09 AM
Help Please, need script If find column width x value, then Split, except last column Word 2012: Change column width changes table width OpfinnarJocke Word Tables 1 09-22-2012 04:03 AM
Help Please, need script If find column width x value, then Split, except last column Column width markg67 Word 2 06-07-2010 07:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:48 PM.


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