How can I pull out position 4 in a string?

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alpha sorting (with a twist...?) 3
Skip Reference Sequences during copy 3
conditional sum? 2
Excel In Excel how can I block the contenent of a cell? 0
How can I paste in the opposite direction? 12
From Rows to column 3
repost: conditional sum? 5
Retrieving info from multiple tables 1

Top