Copying part of a string value to another cell

[SBF12345]

Greetings,

I would like to be able to copy a string value from one cell to another. The string value to copy will be located in the target cell after an "&" and go until the last character in the cell. The length of the string value will vary from cell to cell.

Any ideas as to how something like this might be written?

 

[Rick Rothstein]

Give this formula a try...

=TRIM(MID(A1,FIND("&",A1&"&")+1,LEN(A1)))

 

[SBF12345]

Thanks Rick Rothstein!