Importing and losing & sign

Hi - running into a problem.  I'm importing information from an Excel spreadsheet as a Variant.  However, the "&" sign is replaced with "_".  Anyone know of a way to fix?  Thanks
Who is Participating?

Improve company productivity with a Business Account.Sign Up

VBtormentConnect With a Mentor Commented:

Replace(szstring$, "_", "&")
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.