View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Right justify a string

Hi Robert,

Am Sat, 9 Mar 2013 08:40:07 +0100 schrieb Claus Busch:

s1 = "--------"
s2 = "13"
s3 = Left(s1, Len(s1) - 2) & s2


if s2 is also variable in length better try:
s1 = "--------"
s2 = "13"
s3 = Left(s1, Len(s1) - Len(s2)) & s2


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2