lindajones
New Member
- Joined
- Apr 8, 2003
- Messages
- 4
Hi,
I am working with a spreadsheet of names and addresses. The data was entered in lowercase but I would like to convert it all to uppercase. I have tried the UPPER function, but that does not seem to convert text already entered within the same cell. I am looking for a solution that would allow me to convert all the cells as they are without have to cut and paste. Any ideas??
Thanks!
Linda
I am working with a spreadsheet of names and addresses. The data was entered in lowercase but I would like to convert it all to uppercase. I have tried the UPPER function, but that does not seem to convert text already entered within the same cell. I am looking for a solution that would allow me to convert all the cells as they are without have to cut and paste. Any ideas??
Thanks!
Linda