find a character in a string
 

hi
i have a column of text data

i would like to search over the column and search each string for the
char "/"

if it exists in the string i would like to delete it and leave space
in its place

thanks kevin

find a character in a string
 

Ctrl + H, in find what put /, in replace with put a space, then select
replace all


--
Regards,

Peo Sjoblom


"kevcar40" wrote in message
ups.com...
hi
i have a column of text data

i would like to search over the column and search each string for the
char "/"

if it exists in the string i would like to delete it and leave space
in its place

thanks kevin

find a character in a string
 

Either select your column and:
Edit
Replace
Find what: /
Replace with: {type in a space}
or use the formula
=SUBSTITUTE(A1,"/"," ")
--
David Biddulph

"kevcar40" wrote in message
ups.com...
hi
i have a column of text data

i would like to search over the column and search each string for the
char "/"

if it exists in the string i would like to delete it and leave space
in its place

thanks kevin

find a character in a string
 

select the column
<edit<replace
enter / in find
and a sapce in replace with

"kevcar40" wrote:

hi
i have a column of text data

i would like to search over the column and search each string for the
char "/"

if it exists in the string i would like to delete it and leave space
in its place

thanks kevin

find a character in a string
 

On 4 Jun, 20:45, bj wrote:
select the column
<edit<replace
enter / in find
and a sapce in replace with



"kevcar40" wrote:
hi
i have a column of text data

i would like to search over the column and search each string for the
char "/"

if it exists in the string i would like to delete it and leave space
in its place

thanks kevin- Hide quoted text -

- Show quoted text -

thanks all