Finding the middle character in a word ??

[asetat]

Hi there dear folks,

Is it possible to find out the middle character in a word which is written in a specific cell in excel.

I mean let's say, I wrote "MrExcel" in a cell and I want to discover the "x" with some formula..

any idea please?

 

[DonkeyOte]

=MID(A1,ROUND(LEN(A1)/2,0),1)

Will pull 4th char in both 6 & 7 char string (like MrExcel) -- assumes cell is whole (ie no blanks - MrExcel not Mr_Excel)

 

[asetat]

thank you for your reply but when I tried it says there's a problem with the formula?

 

[Richard Schollar]

...and the problem is?

 

[asetat]

this is the error message " the formula you typed contains an error"

that's all.

 

[Richard Schollar]

Check the placement of the brackets in your formula - you have most likely omitted one.

 

[asetat]

I just copy-paste from here.. same error continues..

dear richard, does it work for you?

 

[RoryA]

Which language version of Excel and do you normally use ; instead of , in your formulas? If so try:

=MID(A1;ROUND(LEN(A1)/2;0);1)

 

[asetat]

Which language version of Excel and do you normally use ; instead of , in your formulas? If so try:

=MID(A1;ROUND(LEN(A1)/2;0);1)

thank you rorya..

";" instead of "," solved my problem

cheers!