How can I pull out position 4 in a string?

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

Column A contains a string

MyString
aaaaaa
bbbbbb
cccccc
dddddd
eeemee
fffmff
gggmgg

I want the value of B1 to be the value of A1 unless the 4th character in A1
is a "m". So column B would be
B1=aaaaaa
B2=bbbbbb
B3=cccccc
B4=dddddd
B5 = empty cell
B6 = empty cell
B7 = empty cell

What's the simplest way to do this?
 
Back
Top