length formula

[webmax]

Hi

I want a formula that if the length of the character is less than 12 digits then it will show as space for the each character up to 12 digit.

For example if the word is "Life" then then Total Length of the word is 4 then the remaining 8 character is show as 8 spaces.

 

[Ravi Verma]

what if the length is more than 12 digits ?

where exactly you need to show blanks in case the length is less than 12 digits ?

 

[webmax]

it take only right of 12 digits

 

[Faseeh]

Hi Ravi,

Try this with your data in A1, replace "*" with space " " if you like:

=IF(LEN(A1)<8,A1&REPT("*",8-LEN(A1)),A1)

 

[Sajan]

Here is one more approach:
=LEFT(A1&REPT(" ",12),12)

 

[Ravi Verma]

Hi Ravi,

Try this with your data in A1, replace "*" with space " " if you like:

=IF(LEN(A1)<8,A1&REPT("*",8-LEN(A1)),A1)

Hi Faseeh,
Please replace 8 with 12... its works excellent..

 

[Ravi Verma]

Here is one more approach:
=LEFT(A1&REPT(" ",12),12)

Perfect Sajan

 

[shrivallabha]

One more:
=REPLACE(REPT(" ",12),1,LEN(A1),A1)

 

[Debraj]

one less..
=A1&REPT(" ",12-MIN(12,LEN(A1)))

 

[shrivallabha]

Deb,

Only in theory. That is one character less but add MIN & CONCAT functions .