| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
USE PART OF TEXT FROM ONE CELL IN ANOTHER
I have the following in one cell NAME fred /bloggs/ then down to cells
with other info in them before another cell with NAME freda /bloggs/ etc I have discovered how to check for the existance of "NAME" in a cell but how can I copy the "fred" and "bloggs" to other cells when the "NAME" exists? Is it also possible to check the next cell down if "NAME" doesn't appear in a cell and carry on to the next other cell down so that I get fred bloggs freda bloggs etc ? -- Thanks Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Extracting part of Text from one cell to another | Excel Worksheet Functions | |||
| removing part of text string to another cell | Excel Discussion (Misc queries) | |||
| Code to get text from part of a cell | Excel Worksheet Functions | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
Threaded Mode
