Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good morning,
I have previously tried posting this but apparently the solution is quite complicated. The result in the end gives quite a long winded table that then needs filtered and whatever. Does anyone else have any ideas? ----------------------------- I have a list of dt 7a (mixture of text and numbers) arranged in a horizontal column such as below, (for ref 563 ET 761 is the contents of one cell, all fields below are single cells, just some have spaces). Row 10 inputs are --- 0 0 563 ET 761 2 7 5N F0,035 Row 11 inputs are -- 4N F6 2 10 25 CU 3 4 ET 7 12 The contents of the non numeric cells are completely changeable between different characters, numbers, spaces and position in the horizontal row. I would like to output, in adjacent cells (cols A, B, C for example) in row 12 and 13 just the non numeric data. Row 12 - 563 ET 761 5N F0,0035 Row 13 - 4N F6 25 CU 3 4 ET 7 There are no only numerical cells that i need to output, just the cells that contain mixed text and numbers. Does anyone know the simplest way to create this output? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help! I can't get any search results | Excel Discussion (Misc queries) | |||
Search Results | Excel Discussion (Misc queries) | |||
Highlight Search Results | Excel Discussion (Misc queries) | |||
multiple results from search / how to? | Excel Discussion (Misc queries) | |||
Print the results of a search | Excel Discussion (Misc queries) |