Hi all, I am trying to create a global exclusion list and then import it to a
registry file. I have no problems importing this in excel so that I can edit
it but then I need to do the following
1) format the data so that the final data looks like this
quot;winnt.exequot;=dword:00000000
now in column a I have the winnt.exe and I have no problems using
concatenate to add the =dword:00000000
But what I cannot get to happen is adding the quotes before the winnt.exe
and the quotes after the winnt.exe
I must use double quotes any help would be appriciated.
Thanks,
One way
=char(34)amp;quot;winnt.exequot; amp; char(34)
quot;Speed2772quot; wrote:
gt; Hi all, I am trying to create a global exclusion list and then import it to a
gt; registry file. I have no problems importing this in excel so that I can edit
gt; it but then I need to do the following
gt;
gt; 1) format the data so that the final data looks like this
gt; quot;winnt.exequot;=dword:00000000
gt;
gt; now in column a I have the winnt.exe and I have no problems using
gt; concatenate to add the =dword:00000000
gt;
gt; But what I cannot get to happen is adding the quotes before the winnt.exe
gt; and the quotes after the winnt.exe
gt;
gt; I must use double quotes any help would be appriciated.
gt;
gt; Thanks,
Another way
=quot;quot;quot;quot;amp;quot;winnt.exequot;amp;quot;quot;quot;quot;--
Regards,
Peo Sjoblomquot;Duke Careyquot; gt; wrote in message
...
gt; One way
gt;
gt; =char(34)amp;quot;winnt.exequot; amp; char(34)
gt;
gt; quot;Speed2772quot; wrote:
gt;
gt; gt; Hi all, I am trying to create a global exclusion list and then import it
to a
gt; gt; registry file. I have no problems importing this in excel so that I can
edit
gt; gt; it but then I need to do the following
gt; gt;
gt; gt; 1) format the data so that the final data looks like this
gt; gt; quot;winnt.exequot;=dword:00000000
gt; gt;
gt; gt; now in column a I have the winnt.exe and I have no problems using
gt; gt; concatenate to add the =dword:00000000
gt; gt;
gt; gt; But what I cannot get to happen is adding the quotes before the
winnt.exe
gt; gt; and the quotes after the winnt.exe
gt; gt;
gt; gt; I must use double quotes any help would be appriciated.
gt; gt;
gt; gt; Thanks,
- Jul 20 Thu 2006 20:08
Can I format a cell to include quotes quot; quot;
close
全站熱搜
留言列表
發表留言