Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a character location in a string starting from the right | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Find last occurance of character in text string | Excel Worksheet Functions | |||
Splitting Character String | Excel Worksheet Functions | |||
Find nth instance of a character in a string | Excel Discussion (Misc queries) |