Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
function for search | Excel Discussion (Misc queries) | |||
Search Function | Excel Worksheet Functions | |||
Search function | Excel Worksheet Functions | |||
Search function | Excel Discussion (Misc queries) | |||
Search Function.. | New Users to Excel |