Jump to content

Excel help


Jatka Bandi

Recommended Posts

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.. 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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…

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

  • Haha 1
Link to comment
Share on other sites

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…?

Link to comment
Share on other sites

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…

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...