HELP: How to Reverse Cell Content

T

talk2mide

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

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

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

Biff

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)
Click to expand...

=LEN(A1)

Counts ALL characters including spaces and punctuation marks.

Biff
 
J

Jef Gorbach

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