Prev: creating a graph from a drop down menu
Next: Change cell color for valid if statement
From: jkc on 9 Feb 2010 11:09
I would like to delete ' and an s in a set of numbers within a cell how do
you efficently do this through out a data set. (example 344'6s = 3446 in
cell only)
--
jkc
From: Bob I on 9 Feb 2010 11:13
Find ' and replace with blank, then again with the s

jkc wrote:

> I would like to delete ' and an s in a set of numbers within a cell how do
> you efficently do this through out a data set. (example 344'6s = 3446 in
> cell only)

From: Eduardo on 9 Feb 2010 11:18
Hi,
do you always have ' and s in your data if yes highlight the data, press
CTRL H
find what enter ', then in replace with don't enter anything and click on
the replace all button, do the same with the s

"jkc" wrote:

> I would like to delete ' and an s in a set of numbers within a cell how do
> you efficently do this through out a data set. (example 344'6s = 3446 in
> cell only)
> --
> jkc
 | 
Pages: 1
Prev: creating a graph from a drop down menu
Next: Change cell color for valid if statement