Forum Discussion
Excel Formatting Question: Custom formatting for Text
Markus64 What an interesting question. I suspect this is not possible and it can't be compared with date formatting. Since dates have a given structure (year, month, day) one can format a cell to display only part of the entire structure. A text, on the other hand, is just a string of characters. But I can't help wondering why you would want to type the whole word and only display the first letter. Can you elaborate a little? Perhaps there is another way to achieve what you want.
Hi Riny,
many thanks for your answer.
I would have the whole word in the drop down list (e.g. Vacation). If you select it will be filled in the cell.If you have a calendar overview for many people for a whole month or more, it's quite easier to have only the first letter shown in the cell.
The other way round you would have the first letters only in the drop down list.
At the end it's a question of user-friendliness and better overview. 🙂However, it was a nice try to challenge Excel functionality.
The workaround will be a duplicate table where I will use the LEFT function.
If you have a better idea, let me know.
Regards
MarkusMarkus64 I see! Consider including a legend in your calendar overview so that the user knows that V stands for Vacation, S for Sick etc.
This can be one row across the top or bottom of the overview. Just an idea but perhaps not a solution you can live with. Up to you!
