Excel help

[Jatka Bandi]

i have varying string lengths in a column. I want all cells to have fixed length.. so if some cells have fewer characters, i want trailing spaces so that each cell makes up that fixed length.. how?

for example,

cells may look like

dg

aknb

2

gshjhj

 

i want them to look like a fixed length of 6. so cells should end up looking like

dg   

aknb  

2     

gshjhj

first, second third cells lo characters taravata space include ayyindi choodandi.. so that all cells are 6 characters.. 

[dasari4kntr]

Try padding functions…

“Dasari”&REPT(“*”,3))

Dasari***

[Jatka Bandi]

25 minutes ago, dasari4kntr said:

Try padding functions…

“Dasari”&REPT(“*”,3))

Dasari***

* badalu white space pedithey teesukotledu. White space ni character laaga define cheyyali.. adi avvatledu.. also, nee suggestion lo Dasari word ee variable length vuntey * kooda adapt avvali.. so that overall charcaters are 15.. ela chestaaru?

[dasari4kntr]

2 minutes ago, Jatka Bandi said:

* badalu white space pedithey teesukotledu. White space ni character laaga define cheyyali.. adi avvatledu.. also, nee suggestion lo Dasari word ee variable length vuntey * kooda adapt avvali.. so that overall charcaters are 15.. ela chestaaru?

Len(“dasari”) gives length of your name…

adjust your cell formatter…and also…
once you done with space…export to cav and notice there is space is appearing or not…

 

[Jatka Bandi]

for example I tried this for 5 character length. but * badalu space pedithe accept cheyatledu. deeniki kooda script rayaala ippudu!

=LEFT(A1&"*****",5)

[DummyVariable]

=IF(VALUE(LEN(E2))=1,E2&"     ",IF(VALUE(LEN(E2))=2,E2&"    ",IF(VALUE(LEN(E2))=3,E2&"   ",IF(VALUE(LEN(E2))=4,E2&"  ",IF(VALUE(LEN(E2))=5,E2&" ",E2)))))

😆

[DalchanChekka]

4 minutes ago, DummyVariable said:

=IF(VALUE(LEN(E2))=1,E2&"     ",IF(VALUE(LEN(E2))=2,E2&"    ",IF(VALUE(LEN(E2))=3,E2&"   ",IF(VALUE(LEN(E2))=4,E2&"  ",IF(VALUE(LEN(E2))=5,E2&" ",E2)))))

😆

0

[DummyVariable]

14 minutes ago, DalchanChekka said:

0

Put data in Cell E2 uncle 

[Jatka Bandi]

20 minutes ago, DummyVariable said:

=IF(VALUE(LEN(E2))=1,E2&"     ",IF(VALUE(LEN(E2))=2,E2&"    ",IF(VALUE(LEN(E2))=3,E2&"   ",IF(VALUE(LEN(E2))=4,E2&"  ",IF(VALUE(LEN(E2))=5,E2&" ",E2)))))

😆

then why smiley at the end?

[DummyVariable]

2 minutes ago, Jatka Bandi said:

then why smiley at the end?

For fun uncle

 

[dasari4kntr]

48 minutes ago, Jatka Bandi said:

for example I tried this for 5 character length. but * badalu space pedithe accept cheyatledu. deeniki kooda script rayaala ippudu!

=LEFT(A1&"*****",5)

Left function deniki? What if A1 is more than 5 characters…?

[Jatka Bandi]

5 minutes ago, dasari4kntr said:

Left function deniki? What if A1 is more than 5 characters…?

in my case, it can never be.

[DalchanChekka]

9 minutes ago, DummyVariable said:

For fun uncle

 

:S

[DummyVariable]

2 minutes ago, DalchanChekka said:

:S

[dasari4kntr]

1 minute ago, Jatka Bandi said:

in my case, it can never be.

Then it will work for you…

space might not visible in excel until unless you custom format cell (try custom formatter ############)

else export to csv and open in notepad and see spaces are there or not…