chuf
Well-known Member
- Joined
- Jun 12, 2006
- Messages
- 619
I'm confused.
I'm working my way through a series of steps on my current project and I thought this bit would be easy...
i need various columns to be various widths due to the upload requirements of the IT system. The columns will, mostly,contain text.
In the case of column G it will be arrived at by concatenating two other columns of text.
The column width must be 40 and the text MUST be contained within that column width, i.e. no overhanging appearance.
No problem i thought = Len function. But despite the Len being 40, the characters are wider than the 40 width
I guess i could set the Len to 30 to be "sure" but i'd like to know if there is a VBA solution to set the characters / string to fit within the specific column width.
To summarise: I'd like a VBA code to concate two columns to arrive at text within a maximum column width of 40, deleting the "excess".
Thanks in advance of your help, again Chuf
I'm working my way through a series of steps on my current project and I thought this bit would be easy...
i need various columns to be various widths due to the upload requirements of the IT system. The columns will, mostly,contain text.
In the case of column G it will be arrived at by concatenating two other columns of text.
The column width must be 40 and the text MUST be contained within that column width, i.e. no overhanging appearance.
No problem i thought = Len function. But despite the Len being 40, the characters are wider than the 40 width
I guess i could set the Len to 30 to be "sure" but i'd like to know if there is a VBA solution to set the characters / string to fit within the specific column width.
To summarise: I'd like a VBA code to concate two columns to arrive at text within a maximum column width of 40, deleting the "excess".
Thanks in advance of your help, again Chuf