find space between first name(inits) and second name

[Scottish Dude]

Can anyone help me.
I have a column full of contact names. Each cell has Init(s) Name. Can anyone help me with some code to change each cell in the column to read Name Init(s)
I have been using the functions , left, mid, right to do this, But as each cell could contain any number of inits this is very time consuming. I have been trying to work out how to do this by using function to find the space between the inits and name then try to select a nos of characters either side of the space.
I am getting nowhere.

using excel (office xp)

 

[Norie]

Can you post an example of your data, perhaps using Colo's HTML Maker?

If you can't post using this (there have been problems recently) just include an example in the post.

 

[2rrs]

Perhaps some variation of this:

Change Mary J. Smith
to Smith, Mary J.

=SUBSTITUTE(MID(A6,FIND(".",A6)+2,100),".","")&", "&LEFT(A6,FIND(".",A6))

 

[Mark W.]

Book1
	A	B	C	D	E	F
1	Mary J Smith	5	Smith, Mary J
2	Mary J. Smith	5	Smith, Mary J.
3	A.J. Foyt	4	Foyt, A.J.
4
5
6
7
Sheet2