Convert a String into Palindrome

[Asheesh]

Hi Experts - I was given a string and asked to reverse the string in the next cell i.e. it should be a palindrome, but without using vba or helper columns..

I tried my best to convert it however it doesnt seem to be possible with single formulae..

My Approach -

I first split each character across the rows and then I am stuck because concatenate is not compatible with arrays..

Any help or guidance will be much appreciated..

 

[Deepak]

I found it somewhere!!

check it helps..

=TRIM(LEFT(RIGHT(" "&A1,1),1)
&LEFT(RIGHT(" "&A1,2),1)
&LEFT(RIGHT(" "&A1,3),1)
&LEFT(RIGHT(" "&A1,4),1)
&LEFT(RIGHT(" "&A1,5),1)
&LEFT(RIGHT(" "&A1,6),1)
&LEFT(RIGHT(" "&A1,7),1)
&LEFT(RIGHT(" "&A1,8),1)
&LEFT(RIGHT(" "&A1,9),1)
&LEFT(RIGHT(" "&A1,10),1)
&LEFT(RIGHT(" "&A1,11),1)
&LEFT(RIGHT(" "&A1,12),1)
&LEFT(RIGHT(" "&A1,13),1)
&LEFT(RIGHT(" "&A1,14),1)
&LEFT(RIGHT(" "&A1,15),1)
&LEFT(RIGHT(" "&A1,16),1)
&LEFT(RIGHT(" "&A1,17),1)
&LEFT(RIGHT(" "&A1,18),1)
&LEFT(RIGHT(" "&A1,19),1)
&LEFT(RIGHT(" "&A1,20),1))

 

[Asheesh]

Deepak - Thank you...I Initially thought of the same solution, however, this formula is limited to 20 characters...but I am looking for a formula which can deal with a variable length..

 

[NARAYANK991]

Hi Asheesh ,

One way is shown here :

http://www.mrexcel.com/forum/lounge-v-2-0/224124-challenge-ramblings-palindromes-2.html

You will have to go through one of the posts carefully.

Narayan