Hi Eve,

Am Tue, 9 Oct 2012 18:58:28 +0200 schrieb Eve:

I have an Excel 2007 file with text data in 2 columns like this:
X1 A
X2 B
X3 C
X4 D
X5 E
X6 F
etc.

For some purposes I have to save the date in another file
in the following way:
X1 B
X2 A
X3 D
X4 C
X5 F
X6 E
etc.

we need some more information.
Is the character always "X"? Does the following number always have 1
digit? Is there only 1 character in column 2?
For your example try following formula for the character in column 2:
=IF(ISODD(RIGHT(A1,1)),CHAR(RIGHT(A1,1)+65),CHAR(R IGHT(A1,1)+63))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2