| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting Text
Data/ text to columns
Delimited / -- David Biddulph jazzzbo wrote: I have a worksheet with data split by a "/" eg. BARRISTER/F. GREY I want to split the data into two adjacent columns eg "BARRISTER", "F. GREY" I have tried =LEFT(A1,FIND("/",A1)-1) for the first field, which works, and =MID(A1,FIND("/",A1,99)for the second, which doesn't, of course (I understand why). What should I do,instead, please? Jim Berglund |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Text? | Excel Discussion (Misc queries) | |||
| Splitting text | Excel Discussion (Misc queries) | |||
| Splitting Text | New Users to Excel | |||
| splitting text in a cell.. | Excel Discussion (Misc queries) | |||
| Splitting Up Text in One Cell To Many | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
