I have been asked to complete an excel spreadsheet thing. But i have a
question. The spreadsheet has list of names and other details in each
column. For the column after the names, i need to do the following.

"This is the 2nd, 3rd and 5th characters from the Client's last name
excluding andy punctuation. If there is not enough letters to use the
2nd, 3rd and 5th characters then the number 2 is used to substitute the
missing characters."

So if a clients name was:
"Joe Somebody"

Then the next column should contain:
"omb" [Joe S*om*e*b*ody]

But if their name was:
"Joe Bump"

Then the next column should contain:
"um2" [Joe B*um*p] (cos there isnt a 5th, it is then substituted with a
'2')

But I do not know how to put this in place for 1 cell, let alone the
whole column. I think there might be some code written for this?

Any help is much appreciated, thanks.


--
Murty
------------------------------------------------------------------------
Murty's Profile: http://www.excelforum.com/member.php...o&userid=31255
View this thread: http://www.excelforum.com/showthread...hreadid=509302