Hi All,

I am trying to figure out how to automatically populate cells based on whether specified cells contain a certain character, for example:

A1______________B1______________C1
1234*___________ 4567__________1234
1234 ____________4567*_________4567

Both columns, A and B, will be populated with mobile phone numbers, and when the mobile number is followed by an "*", then I require C1, to automatically populate with that mobile number, 1234.

I hope this makes sense

Thanks,
Alyshia