Asked by .

In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?


A

B

C

D

1

Customer

Street

Territory

Country

2

Terry Stewart

707 Collins St, Docklands

VIC 3008

Australia

3

Che Price

177 William St, Tennant Creek

NT 0860

Australia

4

Stanley Moss

430 Little Collins St,

CXI 6798

Australia

5

Clay Casey

250 Queen St, Sydney

NSW 3000

Australia


=RIGHT(C5,4)



=RIGHT(4,C5)



=LEFT(C5,4)



=LEFT(4,C5)

All Answers 1

Answered by GPT-5 mini AI
A — =RIGHT(C5,4)

This returns the last four characters of C5 ("NSW 3000"), i.e. "3000". The other forms either use the wrong function (LEFT) or wrong argument order.