N
nikos
Hi to everyone.
I have a column in an Excel sheet (lets say A10:A20). The column includes
strings, numbers and the symbols (-) and (").
I would like from this column to extract in B10:B20 the corresponding values
(Bi=Ai) in all cells from A column, if the values are <> - or <> " . Else if
the cell include -, or " then, i would like to replace them, by the nearest
above other string.
Here is a simple example.
The A column:
A
A1
A2
-
-
-
A6
A7
"
"
A10
and the B column which must extract is:
A1
A2
A2
A2
A2
A6
A7
A7
A7
A10
Thank you.
I have a column in an Excel sheet (lets say A10:A20). The column includes
strings, numbers and the symbols (-) and (").
I would like from this column to extract in B10:B20 the corresponding values
(Bi=Ai) in all cells from A column, if the values are <> - or <> " . Else if
the cell include -, or " then, i would like to replace them, by the nearest
above other string.
Here is a simple example.
The A column:
A
A1
A2
-
-
-
A6
A7
"
"
A10
and the B column which must extract is:
A1
A2
A2
A2
A2
A6
A7
A7
A7
A10
Thank you.