if statement - remove the data in a cell

[ncapanzana]

Hello,

I need a formula to run in B column where

if the value in column A DOES NOT START WITH 'UK', remove the value/data in column B

Expected results

A	B	C
UK1235455	anyvalue1	anyvalue1
UK8941521	anyvalue24	anyvalue24
GS8945122	anyvalue345
LM8944551	anyvalue84
UK8941122	anyvalue14	anyvalue14​

<tbody>
</tbody>

 

[Peter_SSs]

Jim's code is working.. there was a change in the column.. Instead of column B the data i now in column BA.. can you edit the code to reflect the new changes.

Hint: Look at c.Offset(, 1)
That line was offsetting the answer 1 column (from column A to column B)
How many columns do you need to offset from column A now?