How to convert capital letters to small letters in MS excel?

Let’s learn how to convert capital letters to small letters in MS excel. The most accurate or helpful solution is served by Yahoo! Answers.

There are ten answers to this question.

Best solution

Answer:

Though you could use the LOWER function in a formula, that does not do much good when you wish to convert...

Read more

debajit d at Yahoo! Answers Mark as irrelevant Undo

Other solutions

Answer:

Example: cell A1: MINERVA cell B1, type this =LOWER(A1) will result minerva in B1 cell C1, type this...

Read more

minerva at Yahoo! Answers Mark as irrelevant Undo

How can I more easily edit CSV tables in Access or Excel?

I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get...

Answer:

I think the main problem you're running into is that, when you link to a CSV file from Access, the result...

Read more

filthy light thief at Ask.Metafilter.Com Mark as irrelevant Undo

Answer:

You can write your own macros using excel functions like =UPPER(), =LOWER(), and =PROPER() to solve...

Read more

community wiki at wiki.answers.com Mark as irrelevant Undo

Answer:

If this was MS-Access, then a simple Query could handle this in a matter of seconds. But you will need...

Read more

Kristal H at Yahoo! Answers Mark as irrelevant Undo

Answer:

The answer depends on the version of word your using. But the basic answer is in the commands at the...

Read more

Abuderaz... at Yahoo! Answers Mark as irrelevant Undo

Formula

I need to find the formula for anniversary years. Say the league started in 1980, I need my next column to show me the updated amount of anniversary years. I am tring to add time. Example; 12:48 a.m 1:24 a.m. answer, 26 minutes What is the formula...

Answer:

Not clear what the question is - are you looking for the number of years between two dates? If so, the...

Read more

Miningco.com Mark as irrelevant Undo

How to convert the Figure into words using MS Excel. Urgent Help required.....?

When I use the =spellnumber(101521) command in MS Excel, I get the answer as One Hundred One Thousand Five Hundred Twenty One. But I want to get the result as "One Lac One Thousand Five Hundred Twenty One"

Answer:

1. Alt+F11, click through the modules (module1, Thisworkbook, or Sheet1 etc) to locate the Function...

Read more

MAGGY@YA... at Yahoo! Answers Mark as irrelevant Undo

How to convert my Excel address into a single column in MS Word?

My addresses in Excel are in rows. Such as Bob Smith 1234 Any St Anytown AA 01234 Mary Smith 1234 Any St Anytown AA 98765 Please give detailed instructions or a link. I want them to appear in MS Word as Bob Smith 1234 Any St Anytown AA 01234 Mary Smith...

Answer:

Use mailmerge feature http://office.microsoft.com/en-us/excel-…

Read more

alex at Yahoo! Answers Mark as irrelevant Undo

What are the significant improvements of MS Excel 2013 compared to MS Excel 2010?

I use Excel a lot. I am wondering if I should upgrade from 2010 to 2013. What are the significant improvements of MS Excel 2013 compared to MS Excel 2010?

Answer:

Flash Fill - Predict what items you want to input into a cell (time saver) Quick Analysis - Quick options...

Read more

Rick Grantham at Quora Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.