| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Name from Text
I got below data in Range("A1:A4")
C:\Documents\Deal\Tony Jayes.xlsm C:\Documents\Records\John Smith (Survey Form).xlsm C:\Documents\Project\Michael Taylor - MCC.xlsm C:\Documents\Records\Simon Craig (FTT).xlsm I need some formula or macro to get result in Range("B1:B4") like below Tony Jayes John Smith Michael Taylor Simon Craig Basically I want names to be extracted from column A Text. Please can anyone can help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refer a cell text in b1 and extract remaing text from a1 | Excel Discussion (Misc queries) | |||
| How to extract text from number/text cell | Excel Worksheet Functions | |||
| Need to extract certain text from text string | Excel Worksheet Functions | |||
| Extract text from large Text | Excel Discussion (Misc queries) | |||
| EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
