HELP: How to Reverse Cell Content

Does anyone know how to reverse cell content (text) using the following example:

Reverse cell A1 ("smith, bob") to ("bob smith") and apply results in B1?

Additionally, any hints on counting text letters in cells ("xxxxxx" would equal 6)

Try

=MID(A1,FIND(",",A1)+2,LEN(A1))&" "&LEFT(A1,FIND(",",A1)-1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"talk2mide"
<talk2mide.29vrbb_1151108401.7314@excelforum-nospam.com> wrote in
message
news:talk2mide.29vrbb_1151108401.7314@excelforum-nospam.com...
>
> Does anyone know how to reverse cell content (text) using the
> following
> example:
>
> Reverse cell A1 ("smith, bob") to ("bob smith") and apply
> results in
> B1?
>
> Additionally, any hints on counting text letters in cells
> ("xxxxxx"
> would equal 6)
>
>
> --
> talk2mide
> ------------------------------------------------------------------------
> talk2mide's Profile:
> http://www.excelforum.com/member.php...o&userid=35731
> View this thread:
> http://www.excelforum.com/showthread...hreadid=555165
>

>Reverse cell A1 ("smith, bob") to ("bob smith")

=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

> Additionally, any hints on counting text letters in cells ("xxxxxx"
> would equal 6)

=LEN(A1)

Counts ALL characters including spaces and punctuation marks.

Biff

"talk2mide" <talk2mide.29vrbb_1151108401.7314@excelforum-nospam.com> wrote
in message news:talk2mide.29vrbb_1151108401.7314@excelforum-nospam.com...
>
> Does anyone know how to reverse cell content (text) using the following
> example:
>
> Reverse cell A1 ("smith, bob") to ("bob smith") and apply results in
> B1?
>
> Additionally, any hints on counting text letters in cells ("xxxxxx"
> would equal 6)
>
>
> --
> talk2mide
> ------------------------------------------------------------------------
> talk2mide's Profile:
> http://www.excelforum.com/member.php...o&userid=35731
> View this thread: http://www.excelforum.com/showthread...hreadid=555165
>

might consider doing =len(trim(A1)) to remove any leading/trailing spaces
first

"Biff" <biffinpitt@comcast.net> wrote in message
news:#BybqFzlGHA.748@TK2MSFTNGP02.phx.gbl...
> >Reverse cell A1 ("smith, bob") to ("bob smith")
>
> =MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)
>
> > Additionally, any hints on counting text letters in cells ("xxxxxx"
> > would equal 6)
>
> =LEN(A1)
>
> Counts ALL characters including spaces and punctuation marks.
>
> Biff
>
> "talk2mide" <talk2mide.29vrbb_1151108401.7314@excelforum-nospam.com> wrote
> in message news:talk2mide.29vrbb_1151108401.7314@excelforum-nospam.com...
> >
> > Does anyone know how to reverse cell content (text) using the following
> > example:
> >
> > Reverse cell A1 ("smith, bob") to ("bob smith") and apply results in
> > B1?
> >
> > Additionally, any hints on counting text letters in cells ("xxxxxx"
> > would equal 6)
> >
> >
> > --
> > talk2mide
> > ------------------------------------------------------------------------
> > talk2mide's Profile:
> > http://www.excelforum.com/member.php...o&userid=35731
> > View this thread:
http://www.excelforum.com/showthread...hreadid=555165
> >
>
>