Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing the from a cell
How can I remove the (quotation) from the data in a cell? An example of
the data I have is: 3/8X1/2 18 GA GAL Staple. I need to remove the and have the data look like 3/8X1/2 18 GA GAL Staple. The is causing a problem with the import program I am using to import this into a third party program. I have looked at the substitute function but can not get it to accept the as a valid old_text variable to remove. Any help would be greatly appreciated. Thanks |
#2
|
|||
|
|||
Hi Mark,
Have you tried Find & Replace? Ctrl+H. Replace the " with nothing and it should dissappear. Cheers, Jon "MarkM" wrote: How can I remove the (quotation) from the data in a cell? An example of the data I have is: 3/8X1/2 18 GA GAL Staple. I need to remove the and have the data look like 3/8X1/2 18 GA GAL Staple. The is causing a problem with the import program I am using to import this into a third party program. I have looked at the substitute function but can not get it to accept the as a valid old_text variable to remove. Any help would be greatly appreciated. Thanks |
#3
|
|||
|
|||
Thanks Jon, I completely forgot about the find/replace. Sometimes the answer
is so easy that it eludes use. Thanks again. "Springbok" wrote: Hi Mark, Have you tried Find & Replace? Ctrl+H. Replace the " with nothing and it should dissappear. Cheers, Jon "MarkM" wrote: How can I remove the (quotation) from the data in a cell? An example of the data I have is: 3/8X1/2 18 GA GAL Staple. I need to remove the and have the data look like 3/8X1/2 18 GA GAL Staple. The is causing a problem with the import program I am using to import this into a third party program. I have looked at the substitute function but can not get it to accept the as a valid old_text variable to remove. Any help would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
! removing initials and titles from name cell ! | Excel Discussion (Misc queries) | |||
Removing only certain data in a cell | Excel Discussion (Misc queries) | |||
Removing a drop down list from a cell | Excel Discussion (Misc queries) | |||
Removing a space within a cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |