Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Simple I thought, but can anyone help
I have a column of cells with similar to the following text. First Marine Avenue 18 1303 11 1 There will always be a final 4 groups of text numbers, each with a space between, but each having different number of numbers (this particular sequence has 2,4,2,1 - but others may be different, but always 4 groups) The true text ( a series of Road names are potentiaaly all different, having a sequence of words that may be up to 5 words long before the numbers start) I need to extract the 4 groups of numbers into seperate cells, leaving the Road name text in a singe cell. I would then have a table of 5 columns, the first the Road text, and the next 4 columns being the group of numbers, which I would then format as numbers. -- JayW, Hants, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display contents of cell in another cell as part of text string? | New Users to Excel | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
=CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Extracting text from a cell entry | Excel Discussion (Misc queries) |