title: How do you replace a specific character in Column A to values in Column B in Excel?
body: <p>I'm working in Excel. The code below are 4 of the rows in Column A. In Column B I have a series of integers starting from 0. I would like the values in Column B to replace the "?" in Column A. I searched Google for advanced copy and paste and find and replace techniques in Excel, but the results just told me to use paste special. I tried attempting to reference Column B in the Find and Replace tool, but was unable to do so. Any help would be greatly appreciated.</p>
  
  <pre><code>"&lt;class type=""sItemManager::cITEM_PARAM_DATA""&gt;
  &lt;s16 name=""data.mNum"" value=""900""/&gt;
  &lt;s16 name=""data.mItemNo"" value=""?""/&gt;
  &lt;u32 name=""data.mFlag"" value=""1""/&gt;
  &lt;u16 name=""data.mChgNum"" value=""0""/&gt;
  &lt;u16 name=""data.mDay1"" value=""0""/&gt;
  &lt;u16 name=""data.mDay2"" value=""0""/&gt;
  &lt;u16 name=""data.mDay3"" value=""0""/&gt;
  &lt;s8 name=""data.mMutationPool"" value=""0""/&gt;
  &lt;s8 name=""data.mOwnerId"" value=""4""/&gt;
  &lt;u32 name=""data.mKey"" value=""0""/&gt;
  &lt;/class&gt;"
  "&lt;class type=""sItemManager::cITEM_PARAM_DATA""&gt;
  &lt;s16 name=""data.mNum"" value=""900""/&gt;
  &lt;s16 name=""data.mItemNo"" value=""?""/&gt;
  &lt;u32 name=""data.mFlag"" value=""1""/&gt;
  &lt;u16 name=""data.mChgNum"" value=""0""/&gt;
  &lt;u16 name=""data.mDay1"" value=""0""/&gt;
  &lt;u16 name=""data.mDay2"" value=""0""/&gt;
  &lt;u16 name=""data.mDay3"" value=""0""/&gt;
  &lt;s8 name=""data.mMutationPool"" value=""0""/&gt;
  &lt;s8 name=""data.mOwnerId"" value=""4""/&gt;
  &lt;u32 name=""data.mKey"" value=""0""/&gt;
  &lt;/class&gt;"
  "&lt;class type=""sItemManager::cITEM_PARAM_DATA""&gt;
  &lt;s16 name=""data.mNum"" value=""900""/&gt;
  &lt;s16 name=""data.mItemNo"" value=""?""/&gt;
  &lt;u32 name=""data.mFlag"" value=""1""/&gt;
  &lt;u16 name=""data.mChgNum"" value=""0""/&gt;
  &lt;u16 name=""data.mDay1"" value=""0""/&gt;
  &lt;u16 name=""data.mDay2"" value=""0""/&gt;
  &lt;u16 name=""data.mDay3"" value=""0""/&gt;
  &lt;s8 name=""data.mMutationPool"" value=""0""/&gt;
  &lt;s8 name=""data.mOwnerId"" value=""4""/&gt;
  &lt;u32 name=""data.mKey"" value=""0""/&gt;
  &lt;/class&gt;"
  "&lt;class type=""sItemManager::cITEM_PARAM_DATA""&gt;
  &lt;s16 name=""data.mNum"" value=""900""/&gt;
  &lt;s16 name=""data.mItemNo"" value=""?""/&gt;
  &lt;u32 name=""data.mFlag"" value=""1""/&gt;
  &lt;u16 name=""data.mChgNum"" value=""0""/&gt;
  &lt;u16 name=""data.mDay1"" value=""0""/&gt;
  &lt;u16 name=""data.mDay2"" value=""0""/&gt;
  &lt;u16 name=""data.mDay3"" value=""0""/&gt;
  &lt;s8 name=""data.mMutationPool"" value=""0""/&gt;
  &lt;s8 name=""data.mOwnerId"" value=""4""/&gt;
  &lt;u32 name=""data.mKey"" value=""0""/&gt;
  &lt;/class&gt;"
  </code></pre>