ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - How do I keep an ending space in a cell? i.e. "Mr. " (https://www.excelbanter.com/excel-discussion-misc-queries/226874-excel-how-do-i-keep-ending-space-cell-i-e-mr.html)

jme123

Excel - How do I keep an ending space in a cell? i.e. "Mr. "
 
How do I retain a space at the end of a cell entry?

I would like a space after "Mr." so the cell entry would be "Mr. ".

Thanks.

Dave Peterson

Excel - How do I keep an ending space in a cell? i.e. "Mr. "
 
I just type the extra space and it's kept for me (in xl2003).

jme123 wrote:

How do I retain a space at the end of a cell entry?

I would like a space after "Mr." so the cell entry would be "Mr. ".

Thanks.


--

Dave Peterson


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com