If cell ="text" =Other text
Closed
calebz
Posts
1
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
18 February 2015
-
18 Feb 2015 à 12:10
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 20 Feb 2015 à 09:36
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 20 Feb 2015 à 09:36
Related:
- If cell contains text from another cell
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- How to delete cell in word - Guide
- Excel multiple lines in one cell - Guide
- Samsung button cell - Phones, PDA & GPS Forum
- Activate cell - Excel Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
20 Feb 2015 à 09:36
20 Feb 2015 à 09:36
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.
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.
