Search first two letter and replace with particular word in table

[HaroonSid]

hi,
i have a table with data
in range c10:c100
i want to replace data with LF To start with LF
For Example
"LF SARFARAZ NK" Replace with "LF"
"LF GULLU G" replace with "LF"
"LF H FAYYAZ G" replace with "LF"
"LF HAROON" replace with "LF"

any Word start with "LF " should replace with "LF"

Thanks

[jindon]

Try

Please Login or Register  to view this content.

[HaroonSid]

Try

Please Login or Register  to view this content.

Thank you sir

[Squeaky]

If you do not want to use VBA you can place this in another column starting on row 10 =IF(LEFT(C10,2)="LF","LF",C10) and drag down. Then copy/paste values back to the C column.