Donate SIGN UP

Excel - Help With Formula Needed

Avatar Image
soapnumpty | 22:52 Tue 24th Feb 2015 | Computers
3 Answers
I know there are some clever computer bods on here so hopefully someone can help me. I have a list of text in column A, and a Yes or No in column B. I have a formula that if you answer Yes in colum B,it copies the text that is in column A and pastes it into another cell. The only trouble is that the paste text starts every word with a capital letter. So for instance if column A says 'The cat in the hat', when it is paste into the new cell it comes out as 'The Cat In The Hat'. Does anyone know of a way round this is so the text is paste exactly as I typed it in column A?

The formula I am using is =IF(Subject!B15="Yes",PROPER(Subject!A15),"")
So if it says Yes in cell B15 it will copy the text that is written in A15 and paste this text into another cell. 'subject' is the name of the sheet in the workbook where the original text I want to copy is written.

Any ideas?
Many thanks
Gravatar

Answers

1 to 3 of 3rss feed

Avatar Image
Remove PROPER? That's what is does, give words with initial caps.
22:57 Tue 24th Feb 2015
Remove PROPER? That's what is does, give words with initial caps.
^In other words use formula
=IF(Subject!B15="Yes",(Subject!A15),"")
Question Author
That's brilliant. Thank you.

1 to 3 of 3rss feed

Do you know the answer?

Excel - Help With Formula Needed

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.