Find replace with itiration

[NAGARAJGOUDA PATIL]

@neil-schipper
data in excel is
state1
state2
state_hey
state_4

i need both find and repalce

[NAGARAJGOUDA PATIL]

@neil-schipper
=CONCATENATE is for joining nly

[Neil Schipper]

@nagarajgouda-patil
Are you not joining

<EA Na=“ + state_1 + #Start” VL=“ + state_1 + ” O=“R”/>

??

[Neil Schipper]

@neil-schipper Are you literally needing to convert state to sate (which I assumed was a typo)?

[NAGARAJGOUDA PATIL]

[NAGARAJGOUDA PATIL]

@nagarajgouda-patil here i did find - and replace but individually i need formula

[Neil Schipper]

@nagarajgouda-patil So your need is complete;y fulfilled, right?

[NAGARAJGOUDA PATIL]

@neil-schipper
i need formaula
what i did in uploaded excel is manual find and replace
i have 100s of data like this

[Neil Schipper]

You dumped an image with no explanation. Is the result column hand-crafted by you to demonstrate needed output, or did you use a formula (with concatenate command)?

but individually i need formula

I’m not sure what you mean. Do you know how to look through Excel’s help documentation for formula commands?

[NAGARAJGOUDA PATIL]

@neil-schipper
thanks for your help