Logo
DiS Needs You: Save our site »
  • Logo_home2
  • Records
  • In Depth
  • In Photos
  • Blog
  • Podcast
  • Search
  • Community
  • Records
  • In Depth
  • Blog
  • Community

THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Boards

Music Social More…

Excel Formulae Proper Lads Assemble!

Jordan_229_2 [Edit] [Delete] 11:17, 1 May '15

Would there have been a quicker way to write this formulae, which ensures a cell is brought through as containing 15 characters no matter how many characters are in the original entry cell?

(IF(LEN(U7)=0,"_______________",IF(LEN(U7)=1,U7&"______________",IF(LEN(U7)=2,U7&"_____________",IF(LEN(U7)=3,U7&"____________",IF(LEN(U7)=4,U7&"___________",IF(LEN(U7)=5,U7&"__________",IF(LEN(U7)=6,U7&"_________",IF(LEN(U7)=7,U7&"________",IF(LEN(U7)=8,U7&"_______",IF(LEN(U7)=9,U7&"______",IF(LEN(U7)=10,U7&"_____",IF(LEN(U7)=11,U7&"____",IF(LEN(U7)=12,U7&"___",IF(LEN(U7)=13,U7&"__",IF(LEN(U7)=14,U7&"_",U7))))))))))))))))

?


Drowned in Sound
  • DROWNED IN SOUND
  • HOME
  • SITE MAP
  • NEWS
  • IN DEPTH
  • IN PHOTOS
  • RECORDS
  • RECOMMENDED RECORDS
  • ALBUMS OF THE YEAR
  • FESTIVAL COVERAGE
  • COMMUNITY
  • MUSIC FORUM
  • SOCIAL BOARD
  • REPORT ERRORS
  • CONTACT US
  • JOIN OUR MAILING LIST
  • FOLLOW DiS
  • GOOGLE+
  • FACEBOOK
  • TWITTER
  • SHUFFLER
  • TUMBLR
  • YOUTUBE
  • RSS FEED
  • RSS EMAIL SUBSCRIBE
  • MISC
  • TERM OF USE
  • PRIVACY
  • ADVERTISING
  • OUR WIKIPEDIA
© 2000-2025 DROWNED IN SOUND