formula to get the middle of a word

[spq24]

I have a list of companies where I want to get the middle of the word for each of the companies. Obviously the length of the strings vary in size so I need it to determine the length of the string and take off three from the left and three from the right (If it's long enough to do that, if not can we do less characters off?).

Example
Franklin Energy would return nklin Ene

and Gardner Denver, Inc. would return dner Denver, I

is this possible?

 

[anandvarma]

try this

Excel Workbook
	A	B
1	Franklin Energy	nklin Ene
2	Gardner Denver, Inc.	ner Denver,
Sheet1