| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parse data where break is a first uppercase character in a string?
I am trying to parse text string cells of various lengths and seperated
by spaces. I have thousands of rows of data. I can parse with break lines at the spaces, however I need to parse where the first whole word is in uppercase and for that word (in this example CURRAMBINE) to be in the same column when parsed. Below are two rows of data of differing lengths as an example: (Row 1) 2 Paddington Avenue CURRAMBINE WA 6028 (Row 2) Currambine Station Carpark 1 Paddington Avenue CURRAMBINE WA 6028 Ideally I would like the data in columns as follows: (Row 1 - Column 1) 2 Paddington Avenue (Row 1 - Column 2) CURRAMBINE WA 6028 (Row 2 - Column 1) Currambine Station Carpark 1 Paddington Avenue (Row 2 - Column 2) CURRAMBINE WA 6028 I hope I have explained this correctly. Any assistance would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Trying to match a text string to a data table, any suggestions? | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| I have ad address in one column. I need to break apart the data | New Users to Excel | |||
Threaded Mode
