| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
writing text to different cell after comparing
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
