Thread: I need to have a certain number of characters in a cell
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default I need to have a certain number of characters in a cell
Hello,

If I understand you correctly you want to fill a string up to 30
characters, for example with some blanks?

=LEFT(A1&REPT(CHAR(32),30),30)

Regards,
Bernd
Reply With QuoteReply With Quote