Insert maiden name into fullname 7

[mars19301]

Is there a cell formula that will insert colum A = "Doe" into "Mary A. K. Smith" so the result is Mary A. K. Doe Smith"?

Thank you in advance for any heko,

 

[Gavona]

Brilliant Yogi.

Gavin

 

[xlbo]

Very nice Yogi - thanks for the explanation as well

Now we jus' gotta find that darn picanic hamper !

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[yogia]

Hi Gavin:
Hi Geoff:

Thanks for your generous remarks ... now let us keep EXCELing!

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[SkipVought]

yogi & xlbobo.

Unbeatable! ;-)

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}