I'm trying to convert text from "upper case" to "lower case" It used to be so easy.
I've followed the instructions but if the text is on D1 and you enter the function in E1 how do you get it back into the cell it belongs in. The text covers more than one cell. I'd appreciate any help anyone can offer.
Thanks, Pat
You need to use PasteSpecial->Values to paste the result into A1
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I can't make that work either.
Pat
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Thanks for that input. Since I am a total novice at these forums could you please tell me exactly how to do that. I have made a dummy work sheet. How do I connect it to this forum? And while we are at it, how do I read previous posts on this subject. Somebody else must have posted this question before.
Pat
For information on how to use the forum please follow one of the links to our how to sections or frequently asked questions!
Navigation bar including the How to...? dropdown
How to videos
Frequently asked questions
To attach a workbook,use the "Post Reply" button, then "Go Advanced", scroll down the page & there is "Manage Attachments" button
In the toolbar at the top is a Search button to search previous posts
As per Roy's instructions I am attaching a dummy work sheet. the information I would llike to change to lower case is now in Cell E15.
Pat
I'm sure the Upper Function can only be used on the whole cell,not part
What does that mean? If you use the =LOWER function shouldn't it leave all the text contained in the cell in lower case? Looking at the dummy sheet, into what cell would I put the function in order for it to work?
I found a tip elsewhere and I now agree with the posts there. his is a very foolish way to have to change case. Retyping the text seems to be a better solution. Thanks for your help but I will retype the information.
Pat
You can use Lower to convert all the text but not parts of the sentence, then copy pastespecial
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks