# QuestionMicrosoft Excel - Basic Question

#### rza_757

##### Junior Member
I am stumped and cannot locate an answer. Please help, and forgive me if this is too low level a question. Thank you

#### Egonic

##### Junior Member
What are you even asking for help with?

If you don't understand how to complete Task 2, then maybe it would be a good start to show the actual formula you need to change.

It should also be rather trivial to lookup the individual parts of the task, so what exactly are you finding so difficult?

#### rza_757

##### Junior Member
What are you even asking for help with?

If you don't understand how to complete Task 2, then maybe it would be a good start to show the actual formula you need to change.

It should also be rather trivial to lookup the individual parts of the task, so what exactly are you finding so difficult?
I'm sorry, I do not know what the formula would be and there is no access to texts, etc. It is a TestOut practice exam. Unfortunately nobody (including instructor) knows. I am wanting to know how to show the first 3 letters in the Abb column in lowercase. the "=lower" formula does not work becuase you cannot specify how much text and the "=left" formula does not work because it will still put the initial letter in uppercase.

I apologize for the question, I would just like to know what the correct formula would be for this particular question. Thank you.

#### mpo

##### Senior member
You can nest functions in Excel.

Egonic

#### Egonic

##### Junior Member
I read it at just taking the first 3 letters and showing them in lowercase, which is trivial such as:
• =LOWER(LEFT(\$A1,3))
Then if you mean you should show the first 3 letters in lowercase and then the rest of the characters in whatever upper/lower combination they have, I guess something like this would do:
• =LOWER(LEFT(\$A1,3)) & RIGHT(\$A1,LEN(\$A1)-3)

Might be a cleaner solution to it, but I can't think of one right now!

EDIT: Added LEN so it gets the proper length of the cell.

Last edited:
igor_kavinski

#### rza_757

##### Junior Member

So, even if I use the "=LOWER" and specify the 3 characters "=LOWER[@Location],3)" it still puts the complete string of text, just in lowercase as illustrated in the screenshot. Thanks everyone for their help.

#### Egonic

##### Junior Member
I don't understand where you got the idea that LOWER takes a second parameter to specify length.

Reading the documentation I don't see it, so it's strange that your whatever site fails to notify you of an invalid formula.

I provided a working solution and I don't have a better one to give you, so nothing more I can help you with.

Good luck!

#### rza_757

##### Junior Member
@Egonic - I thought that was what you were talking about earlier when you wrote
• =LOWER(LEFT(\$A1,3))
with the (\$A1,3) meaning cell A1 and 3 characters of text. Sorry for the misunderstanding. The qestion is wanting me to put, for example the cell that says, "Downtown" to "dow" and I do not know the formula to do that. using =LOWER will put the complete text as "downtown", not "dow"... Maybe I'm overlooking something...