| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract text from large Text
I have large text like this: and I want just :
A-X000-1XS-1XSX1-OUK-5507 I want 1XS in a column and 1XSX1 in another A-Y00-2XXA-2XXAX-OUK-5507 I want 2XXA in a column and 2XXAX in another A-X000-MS-MSX-OUK-5502 I want MS in a column and MSX in another A-Y000-LR-LRR-OUK-5503 I want LR in a column and LRR in another please help, thanks in advance -- Lorenzo DÃ*az Cad Technician |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to embed large number of variables in text inside a text box? | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| Not all text wraps in a cell containing large amount of text | Excel Discussion (Misc queries) | |||
| Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
| Large amount of text in cells - Problem text.xls (1/1) | Excel Discussion (Misc queries) | |||
Threaded Mode
