to remove duplicate text within a cell using formula.

[tell_arshad]

Trying to remove duplicate text within a cell.
Could it be done using formula rather then macros?

[Special-K]

have you got examples?

[karthisiva]

i have data something like below

ARD Alignment and Mechanical ServicesARD Alignment and Mechanical Services
DKC DENT REMOVALDKC DENT REMOVAL
Bill Horton's Healing Massage and HomeopathyBill Horton's Healing Massage and Homeopathy
Annerley Motor InnAnnerley Motor Inn



where i have to remove the duplicate words.

can you please give me step by step to do this

thanks
karthisiva

[AZ-XL]

Hi
Try this one
=LEFT(A1,LEN(A1)/2)

suppose that your data starts from A1 cell then drag down

[karthisiva]

Works fine Great thanks