| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing a quotation mark from a cell through a function.
I would like to use a function(s) to remove a quotation mark from a cell.
Currently I have a cell that users enter a length, such as 11" or 101" and I would to use just the number portion in a subsequent function. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing a quotation mark from a cell through a function.
Say A1 has the value. rather than:
=30+A1 use: =30--LEFT(A1,LEN(A1)-1) this discards the double quote and makes it a number. -- Gary''s Student - gsnu200907 "Ryan" wrote: I would like to use a function(s) to remove a quotation mark from a cell. Currently I have a cell that users enter a length, such as 11" or 101" and I would to use just the number portion in a subsequent function. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing a quotation mark from a cell through a function.
Another way using substitute
=SUBSTITUTE(A1,CHAR(34),)+0 OR =--SUBSTITUTE(A1,CHAR(34),) If this post helps click Yes --------------- Jacob Skaria "Ryan" wrote: I would like to use a function(s) to remove a quotation mark from a cell. Currently I have a cell that users enter a length, such as 11" or 101" and I would to use just the number portion in a subsequent function. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing a quotation mark from a cell through a function.
One way:
A1 = 11" =--LEFT(A1,LEN(A1)-1) -- Biff Microsoft Excel MVP "Ryan" wrote in message ... I would like to use a function(s) to remove a quotation mark from a cell. Currently I have a cell that users enter a length, such as 11" or 101" and I would to use just the number portion in a subsequent function. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing a quotation mark from a cell through a function.
Why -- in that formula ?
What's wrong with + ? -- David Biddulph "Gary''s Student" wrote in message ... Say A1 has the value. rather than: =30+A1 use: =30--LEFT(A1,LEN(A1)-1) this discards the double quote and makes it a number. -- Gary''s Student - gsnu200907 "Ryan" wrote: I would like to use a function(s) to remove a quotation mark from a cell. Currently I have a cell that users enter a length, such as 11" or 101" and I would to use just the number portion in a subsequent function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
| Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
| how to put quotation mark in each cell of the column | Excel Worksheet Functions | |||
| what is single quotation mark left side of cell for | Excel Discussion (Misc queries) | |||
| Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel | |||
Linear Mode
