Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find a character location in a string starting from the right funtipoom Excel Worksheet Functions 2 February 15th 07 01:18 AM
Excel-Match 1st text character in a string to a known character? bushlite Excel Worksheet Functions 2 January 15th 07 07:36 PM
Find last occurance of character in text string JDay01 Excel Worksheet Functions 2 February 14th 06 05:29 PM
Splitting Character String mcertini Excel Worksheet Functions 2 September 12th 05 09:41 AM
Find nth instance of a character in a string Francis Hayes (The Excel Addict) Excel Discussion (Misc queries) 7 January 21st 05 04:44 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"