Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 "winnt.exe"=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, |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
One way
=char(34)&"winnt.exe" & char(34) "Speed2772" wrote: 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 "winnt.exe"=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, |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Another way
=""""&"winnt.exe"&"""" -- Regards, Peo Sjoblom "Duke Carey" wrote in message ... One way =char(34)&"winnt.exe" & char(34) "Speed2772" wrote: 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 "winnt.exe"=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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |