Remove & in field value

[Lucky1]

Hi

I have a field 

Name

& Lucky

& Sagar

I want to remove '& ' and i want output like

Name

Lucky

Sagar

How to do that

[MarcoWedel]

LOAD 

Replace(Name,'& ','') as Name

...

[Lucky1 · Accepted solution]

I found solution

Trim(mid(Name,Index(Name,'& ') + 1)) as Name

[MarcoWedel]

In case your Names always start with '& ', you could just use

Mid(Name,3) as Name

as well

[Lucky1]

Only some names start with '& '