| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Text within a cell
I have a cell with the following info in it and i want to seperate the
text to another 2 cells according to where certain characters fall (vs): St. George's vs Sliema W. I want the end result to show St. George's in one cell and Sliema W. in another (adjacent to it) I'm trying to use the FIND(find_text,within_text,start_num) in combination with RIGHT(text,num_chars) but i cannot seem to sort it out so as to come to the desired result! Can any1 help? M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do I find one word in a set of text in a cell? | Excel Discussion (Misc queries) | |||
| linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
Threaded Mode
