LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default Limiting Characters in a cell and adding spaces to fill the remain

Sorry not sure if subject title is clear.

I need to have only 15 characters in a cell. If the characters in a cell are
less than 15.. i need there to be spaces after the characters to make up 15
in total.

Does this make sense ? can it be done ?

Thanks
Mel
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Limiting cell size to 25 characters pj Excel Discussion (Misc queries) 2 October 3rd 07 02:03 PM
limiting characters in a cell by formula Campbell Excel Discussion (Misc queries) 1 July 26th 06 05:39 PM
Limiting the number of characters in a cell. How? caliskier Excel Discussion (Misc queries) 3 January 12th 06 04:50 PM
limiting or deleting extra characters in a cell dprichard Excel Discussion (Misc queries) 3 October 28th 05 09:57 PM
Limiting characters in a cell Colin Hayes Excel Worksheet Functions 7 December 30th 04 03:20 PM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"