Reversing The Order Of Text In A Cell

[PaulBollard]

Hi,

I am wondering if anybody can help me with a problem I have. I use Microsoft Excel Starter 2010 (Microsoft Office version 14.0).

I am trying to find to formula to reverse the order of text in a cell.

The text I want reversing is in column A and the column I want it reversing into is column B. So this is an example.

Column A.............Column B
Fred Bloggs..........sggolB derF

I would also like to (in another document) do the same thing using columns B and C instead of columns A and B. Presumably the formula would be the same or maybe not?

Any help would be greatly appreciated.

Regards.

Paul.

[xlnitwit]

Hi,

Since you don't have VBA available, or the TEXTJOIN function, any formula will be hideous. Is there a maximum length of text you might have in one cell?

[PaulBollard]

Hi xlnitwit,

Thanks for your reply.

The maximum length of text per cell is 22 characters, which includes one space. Each cell consists of two words, separated by a space.

Paul.

[xlnitwit]

In that case you can get away with this
=MID(A1,22,1)&MID(A1,21,1)&MID(A1,20,1)&MID(A1,19,1)&MID(A1,18,1)&MID(A1,17,1)&MID(A1,16,1)&MID(A1,15,1)&MID(A1,14,1)&MID(A1,13,1)&MID(A1,12,1)&MID(A1,11,1)&MID(A1,10,1)&MID(A1,9,1)&MID(A1,8,1)&MID(A1,7,1)&MID(A1,6,1)&MID(A1,5,1)&MID(A1,4,1)&MID(A1,3,1)&MID(A1,2,1)&LEFT(A1,1)

[sandy666]

you can try with:

Please Login or Register  to view this content.

in module

usage:
=Reverse(A1)

[xlnitwit]

To the best of my knowledge, there is no VBA in Excel Starter Edition.

[sandy666]

Really????
I never use any Starter
but maybe it will help someone else.

[xlnitwit]

It may also work as a good sales pitch to the OP.

[sandy666]

Hm, Excel features that are not fully supported in Excel Starter. Nothing about VBA

but OK, I found there is no VBA in Starter Edition.

Edit:
But I found: Purchase Stndard or Premium....

[AlKey]

Enter in C1 and copy across to W1 and then down

Please Login or Register  to view this content.

then use CONCATENATE function:
Enter in B1 and copy down

Please Login or Register  to view this content.

v

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

1

Fred Bloggs

sggolB derF

s

g

g

o

l

B

d

e

r

F

2

George T Clooney

yenoolC T egroeG

y

e

n

o

o

l

C

T

e

g

r

o

e

G

[PaulBollard]

Thanks very much to xlnitwit, sandy666 and AlKey for all your help.

The suggestion that I ultimately went with was AlKey's suggestion as it worked best with me. However, I've added to all three of your reputations for all your help.

[sandy666]

Thanks and welcome