Pick a specific Cell with a special letter from the entire Row

[veer-india]

For example Row No. 2,3,4 have these cells

a2, b2, c2, d2,....
a3, b3, c3, d3,....
and so on
In one row there is any one single cell which have star "*" in it. How to pick these cells automatically and take to a column ?
here is the example what i want. Thanks In advance.

acowa1	acowb1	*acowc1				*acowc1
acowa2	*acowb2	acowc2				*acowb2
*acowa3	acowb3	acowc3				*acowa3

<tbody>
</tbody>

 

[MarcelBeug]

Suppose destination column = Z and relevant columns are A-Y, enter in Z2 and copy down

=HLOOKUP("*~**",A2:Y2,1,0)