Blank and Numeric field Expresion

[Guest]

I have a query with 2 fields. Field one contains either a number, a blank
record, or a word.

Then I have another field (field 2) that contains just words.

Example

Field 1 Field 2

Word 1 Word A
1234 Word B
(blank record) Wodd B
5678 Word C
(blank record) Word C
Word 2 Word A
Word 1 Word C

I need an expresion that when searching field 1, if it finds a number or a
blank record, populates field 2, if it finds a word, populates field 1.

The result in the example above should be:

Expr1
Word 1
Word B
Word B
Word C
Word C
Word 2
Word 1

Is there an expresion that can do this?

Thanks

 

[Guest]

Expr1: IIf(IsNumeric([Field 1])=-1 Or IsNull([Field 1]),[Field 2],[Field 1])