If cell ="text" =Other text

Closed
Posts
1
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
February 18, 2015
-
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
-
Hello,

I'm looking for a formula that will help me do the following:

If cell contains "Other (please specify)" that value of that cell needs to be changed to the text in the adjacent cell. Otherwise, it needs to stay the same.

Thank you in advance!

1 reply

Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Here is a link to a worksheet in Drop Box I believe does what you are thinking.

https://www.dropbox.com/s/40cdvfts3hwuzq5/Pull%20Certain%20Value%20to%20Text.xlsx?dl=0

The yellow cells are input for the value of "Other" and for test data.

The first section pulls value of "other" from a column and either turns that value (Other) to text or brings over the value that wasn't "Other"

The second section does the same thing except it turns the values that were not "Other" to a blank.

Hope that helps.