Hi,
The easiest way to explain my dilemma is by example. I need a custom
field that is always thirty character spaces long no matter how long
the text is. So for example, lets say the word is PIZZA which is 5
characters, I would need 25 blank spaces afterwards to get to 30
characters in total. Does anybody know what this would look like?
I've tried to use the _ but that doesn't seem to work. Thanks.

Try something like this...

Sub PadText()
Dim str As String

str = "Pizza"
MsgBox str & "!"
str = str & Space(30 - Len(str))
MsgBox str & "!"
End Sub
--
HTH...

Jim Thomlinson


"(E-Mail Removed)" wrote:

> Hi,
> The easiest way to explain my dilemma is by example. I need a custom
> field that is always thirty character spaces long no matter how long
> the text is. So for example, lets say the word is PIZZA which is 5
> characters, I would need 25 blank spaces afterwards to get to 30
> characters in total. Does anybody know what this would look like?
> I've tried to use the _ but that doesn't seem to work. Thanks.
>
>

If your data is in Cell A1 then...

=LEFT(A1,30)&REPT(" ",30-LEN(LEFT(A1,30)))

--
HTH,
Gary Brown
(E-Mail Removed)
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.



"(E-Mail Removed)" wrote:

> Hi,
> The easiest way to explain my dilemma is by example. I need a custom
> field that is always thirty character spaces long no matter how long
> the text is. So for example, lets say the word is PIZZA which is 5
> characters, I would need 25 blank spaces afterwards to get to 30
> characters in total. Does anybody know what this would look like?
> I've tried to use the _ but that doesn't seem to work. Thanks.
>
>

Check your other posts, too.

(E-Mail Removed) wrote:
>
> Hi,
> The easiest way to explain my dilemma is by example. I need a custom
> field that is always thirty character spaces long no matter how long
> the text is. So for example, lets say the word is PIZZA which is 5
> characters, I would need 25 blank spaces afterwards to get to 30
> characters in total. Does anybody know what this would look like?
> I've tried to use the _ but that doesn't seem to work. Thanks.

--

Dave Peterson

On Jul 13, 12:06 pm, Gary Brown
<gary"DeleteThis2SendMeAnEmail".Br...@kinneson.com> wrote:
> If your data is in Cell A1 then...
>
> =LEFT(A1,30)&REPT(" ",30-LEN(LEFT(A1,30)))
>
> --
> HTH,
> Gary Brown
> gary.DeleteThis2SendMeAnEmail.Br...@kinneson.com
> If this post was helpful to you, please select
> ''''''''''''''''YES'''''''''''''''' at the bottom of the post.
>
>
>
> "durs...@gmail.com" wrote:
> > Hi,
> > The easiest way to explain my dilemma is by example. I need a custom
> > field that is always thirty character spaces long no matter how long
> > the text is. So for example, lets say the word is PIZZA which is 5
> > characters, I would need 25 blank spaces afterwards to get to 30
> > characters in total. Does anybody know what this would look like?
> > I've tried to use the _ but that doesn't seem to work. Thanks.- Hide quoted text -
>
> - Show quoted text -

Got it thanks for all the help!