Groups > WordPerfect Office > QuattroPro X3 > Re: QPro V8: : How to add blank spaces to text and numbers ?




Re: QPro V8: : How to add blank spaces to text and numbers ?

Re: QPro V8: : How to add blank spaces to text and numbers ?
Sat, 01 Mar 2008 08:39:49 -060
Methods:
1. Use a numeric format.
2. @Concatenate(A1, "   ")
3. +A1&"   "

Post Reply
QPro V8: : How to add blank spaces to text and numbers ?
Sat, 1 Mar 2008 21:17:28 +0800
Dear Sir,

May I know how to add 3 empty spaces in front and behind  text and numbers ?

 What formula must I use ?

       A                       B                     c

1  PTY         _ _ _PTY     PTY _ _

2  5412           _ _ _5412        5412 _ _ _

3  JHL65

4



Thanks



Low


Post Reply
Re: QPro V8: : How to add blank spaces to text and numbers ?
Sat, 1 Mar 2008 23:29:03 +0800
Hello Kanneth,

Many thanks for your formulas.

Kind Regards

Low


"Kenneth Hobson" <khobson@aaahawk.com> wrote in message 
news:47c96a69$1_3@cnews...
>
> Methods:
> 1. Use a numeric format.
> 2. @Concatenate(A1, "   ")
> 3. +A1&"   "
>
> 


Post Reply
about | contact