provided:
1. you have cells with numeric data inserted as Numbers
2. you only need rows 12 and 13 to be populated
would the following be what you're expecting:

in A12 and A13 respectively:

=IF(ISERROR(OFFSET($A$12,ROW()-13,SMALL(IF(ISTEXT($A$10:$F$10),COLUMN
($A$10:$F$10),""),COLUMN())-1),"",OFFSET($A$12,ROW()-13,SMALL(IF(ISTEXT
($A$10:$F$10),COLUMN($A$10:$F$10),""),COLUMN())-1))
=IF(ISERROR(OFFSET($A$13,ROW()-14,SMALL(IF(ISTEXT($A$11:$F$11),COLUMN
($A$11:$F$11),""),COLUMN())-1),"",OFFSET($A$13,ROW()-14,SMALL(IF(ISTEXT
($A$11:$F$11),COLUMN($A$11:$F$11),""),COLUMN())-1))

then drag/copy right

CTRL+SHIFT+ENTER this as it is an array-formula

pls click YES if this post helped you




On 26 Mar, 10:56, LiAD wrote:
Good morning,

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