3 Questions

K

KellyMcG03

Hello everyone... here goes...

1) I want to know how to nest text functions. I have test that is i
Proper form and has extra spaces, I would like to change it to UPPE
case and Trim the extra spaces. How would I do this?

2) I have date cells formatted mm/dd/yyyy, I would like to change the
to yyyymmdd. How would I do this?

3) I want to limit the amount of characters in a cell (i.e. only 1
characters in one cell). How could I only allow a certain amount o
characters in a cell OR How could I get Excel to count the amount o
characters in a cell?

Thanks for you help!
Kell
 
F

Frank Kabel

Hi
sorry forgot 2+3
2: Why not use 'Format - Cells'?
or for a formula use
=TEXT(A1,"yyyymmdd")
note: this creates a text value

3. See 'Data - Validation' and set your text length
 
Top