how can I delete "*" formated as text
 

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks
--
Perry K

how can I delete "*" formated as text
 

On Thu, 2 Apr 2009 06:20:01 -0700, PerryK
wrote:

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks

The tilde tells Excel to treat the asterisk as a literal.

So in your Find what: string you would enter: ~*
--ron

how can I delete "*" formated as text
 

Hi,

Excel will treat * as a wildcard so use ~* in the 'Find What' field to make
it treat * as a literal character.

Mike

"PerryK" wrote:

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks
--
Perry K

how can I delete "*" formated as text
 

Thanks --- Learn something new every day!!!!
--
Perry K


"Mike H" wrote:

Hi,

Excel will treat * as a wildcard so use ~* in the 'Find What' field to make
it treat * as a literal character.

Mike

"PerryK" wrote:

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks
--
Perry K

how can I delete "*" formated as text
 

Thanks --- Learn something new every day!!!!
--
Perry K


"Ron Rosenfeld" wrote:

On Thu, 2 Apr 2009 06:20:01 -0700, PerryK
wrote:

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks

The tilde tells Excel to treat the asterisk as a literal.

So in your Find what: string you would enter: ~*
--ron

how can I delete "*" formated as text
 

Some more info...

Excel can use wildcards in some functions and operations (edit|find, for
example).

* for any characters
? for any single character
~ as an "escape" character to indicate that the next * or ? should be treated as
an asterisk or question mark--not as wild cards.

So to find an asterisk, you use: ~*
to find a question mark, you use: ~?
to find a tilde, you use: ~~

PerryK wrote:

I have a column that contains names and is formated as "Text".
Some of the cells have a "*" - at the end of the name.

I would like to find a way to delete all of the "*"s.
If I use "Replace" and have it look for * it will replace all of the
contents of the cell.

Is there another way to do this?

thanks
--
Perry K

--

Dave Peterson