Forum Discussion
Excel Formatting Question: Custom formatting for Text
I'd like to use the cell formatting to show only the first letter of the entry of a cell. I know it would be possible to use the left function and upper function to have a capital letter. What I'd ...
Hello, you can use flash fill. Assuming you have
Education
Office
Private Business
Sick
Travel
Vacation
... All in cell A1 and other cells below. In column B1, type in B click Enter and press CTRL + E.
To create list drop down, click on Data Validation under the Data tab and select List from the dropdown. Select all the data yt want and click OK
Education
Office
Private Business
Sick
Travel
Vacation
... All in cell A1 and other cells below. In column B1, type in B click Enter and press CTRL + E.
To create list drop down, click on Data Validation under the Data tab and select List from the dropdown. Select all the data yt want and click OK
Hi Abiola,
many thanks for the prompt answer.
Flash fill will change the entry in the cells.
I'd like to have the entries correctly but only shown the first letter.
e.g. As for a date you could show only the day, even the whole date is in the cell.
Regards
Markus
