Replacing * from a cell 3

[rss01]

Does anybody know how to replace an '*' from a cell.

I've tried a couple different ways but can not do it.

Example:

Cell A1 = S02/A02* and I want it to be S02/A02.

I can use the SUBSTITUTE function, but I want to search the entire spreadsheet.

Thanks

 

[bluedragon2]

One way:

data on sheet1

on sheet 2 cell A1 type:
=SUBSTITUTE(sheet1!A1,"*","&quot

Then copy the cell, select the entire sheet 2 and paste.

Then select entire sheet2, and paste special/values to sheet3

You will now have a sheet without any *'s



Blue

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

If you have a slow PC, I suggest to only paste as big as your sheet1



Blue

If I wasn't Blue, I would just be a Dragon...

 

[DrBowes]

Use ~* and replace as usual.

 

[bluedragon2]

Thats it...

I was looking for that control character and couldn't find it anywhere in my notes.



Blue

If I wasn't Blue, I would just be a Dragon...

 

[rss01]

Thanks, that one worked great.

bluedragon2 - I tried yours but my spreadsheet is to big

 

[SkipVought]

GOOD TIP! ==> *



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com