It has been a while since I used excel to any extent. I have numerous files that were converted from PDF to Excel. There are two columns, Last Name and First Name. When they converted all the letters in each column were capitalized. Is there a way (macro or function) I can use that will leave only the first letter upper case and the rest lower case that I can apply to the entire worksheet or each column?
CoachBarker
Try the PROPER() function in Excel.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hi,
Add a new column and type in the following formula:
=proper(a1)
This is assuming that the word to change is in cell a1. Then drag the formula down. Then highlight the whole of the new column, copy, and paste special (values) back into it. You are then ok to delete the original column. Any good?
Hi,
You can have my solution as an alternative
The 'proper' function will display the sentances as follows (Every first letter in upper case)
Eg: "Excel Forum For Queries"
If you want only the first word of the sentance to be proper, then you can use this function
=PROPER(LEFT(A1,FIND(" ",A1)))&LOWER(MID(A1,FIND(" ",A1),LEN(A1)))
Result: "Excel forum for queries"
Please click 'Add reputation', if my answer helped you.
what if I want to do a range B2 thru B50 and C2 thru C50?
Or like this:Originally Posted by ramananhrm
=PROPER(LEFT(A1,1))&LOWER(MID(A1,2,255))
You'll need to drag your formula down through your range.
If your data looks like this workbook then PROPER() will do the job, drag/Fill E2:D2 downThere are two columns, Last Name and First Name.
thank you all for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks