L
LiAD
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
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