Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi All,
I have one cell (A1) that contains "post, rf on, e109, e10". I would like to extract information from this cell. Meaning, when I click on A2, I want A2 to search A1 cell for the word/text "post", and if the word "post" is in A1, then write "post" in A2 otherwise leave blank (or turn it into a red color). Is this possible? Thanks in advance. thank you, tracktraining -- Learning |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How about a double click. Right click sheet tabview codecopy/paste this
Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, Cancel As Boolean) If Target.Address < Range("a2").Address Then Exit Sub If InStr(Range("a1"), "post") Then Target = "post" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "tracktraining" wrote in message ... Hi All, I have one cell (A1) that contains "post, rf on, e109, e10". I would like to extract information from this cell. Meaning, when I click on A2, I want A2 to search A1 cell for the word/text "post", and if the word "post" is in A1, then write "post" in A2 otherwise leave blank (or turn it into a red color). Is this possible? Thanks in advance. thank you, tracktraining -- Learning |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
One way
In A2: =IF(COUNTIF(A1,"*"&"post"&"*"),"post","") -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "tracktraining" wrote: I have one cell (A1) that contains "post, rf on, e109, e10". I would like to extract information from this cell. Meaning, when I click on A2, I want A2 to search A1 cell for the word/text "post", and if the word "post" is in A1, then write "post" in A2 otherwise leave blank (or turn it into a red color). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a line break writing text within a cell? | Excel Discussion (Misc queries) | |||
using wordwrap in excel for text writing | Excel Worksheet Functions | |||
Comparing columns of text: cell value into array | Excel Discussion (Misc queries) | |||
comparing text against a text table for yes no result | Excel Discussion (Misc queries) | |||
Excel 2007 Problems; in writing macro and convert text to colums | Excel Discussion (Misc queries) |