Replace Function:Replace" and type in

**ronnyc** · 03-19-2007, 06:16 PM

I'm not sure if this is the right place to ask this but...

In a cell I have the following: *12

If I do a simple "Replace" and type in * it zero's out the entire cell.

Is there a way JUST to get rid of the asterisk?

Thanks!!

**VBA Noob** · 03-19-2007, 06:21 PM

Hi,

Try

~*

VBA Noob

**ronnyc** · 03-19-2007, 06:24 PM

THANK YOU THANK YOU THANK YOU!!!

You just saved me HOURS of re-typing in numbers!!!!!!!!!!!!!!!!!!!!!!!!

**VBA Noob** · 03-19-2007, 06:26 PM

Glad it helped

VBA Noob

Replace Function:Replace" and type in

LinkBack

Thread Tools

Rate This Thread

Display

Replace Function:Replace" and type in

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions