Reversing text in Cell

[Mantle51]

Is there an easy way to reverse 2 text elements in a cell?

Basically, last first need to read first last

Thanks.....Mickey

 

[SkipVought]

Hi,

How do you distingusih between the first and last? Delimited by a SPACE?

Are there ALWAYS only two words?

Probably like this

with Cells(lrow, icol)
   a=split(.value," ")
   .value = a(ubound(a)) & " " & a(0)
end with

Skip,

_[red][/red]