abbreviate name from one cell to another is possible?

It's certainly possible. How many names can be in a cell? Always 4?

BTW check this thread:
http://www.excelforum.com/excel-form...ddle-name.html

If you understand the formulas, you can adjust them for your specific case. If you don't, please let me know then I'll make 'em for you

Hi,

These sorts of string slicing functions are perfectly possible but before advising further we need to see more examples of your ACTUAL data not just a single name, unless of course you are saying that names are always compromise 4 words AND you only want the initials for the middle 2.

So attach a workbook with as many examples as you have permutations of names and no doubt someone will be able to offer a generic solution.

Regards

Real-time updating threads while typing replies might be a nice one for the suggestion box, huh?

Originally Posted by paroduso33

its this what i want in the image...Attachment 266369 i can respond now...im going to work....bye and thanks

I can't find any logic in your example. Which ones are the abbreviations? And how should excel know what to add, remove or abbreviate??

Originally Posted by L-Drr

Real-time updating threads while typing replies might be a nice one for the suggestion box, huh?

Nice idea
.... but I suspect that really would bring the server down around us