Posted to microsoft.public.excel.worksheet.functions

Anthony

external usenet poster

Posts: 275

Remove * from value

Is there anyway using find and replace if I have a number and then an *.
Example 5* How can I replace the '*' from the field so that the formula
MAX will work. Any way please. Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
remove convert/extract the number from'12345.56; ie remove ' sign	WAN	Excel Worksheet Functions	2	January 10th 08 12:38 PM
How do I remove hyperlink if 'remove' option is disabled	Vipul	New Users to Excel	1	January 8th 08 02:34 PM
Remove the #DIV/0!	Corey	Excel Worksheet Functions	3	April 27th 07 07:32 AM
Remove ÿ	Otto Moehrbach	Excel Discussion (Misc queries)	2	August 28th 06 03:31 AM
remove an add in from xla	Norman Smith	Excel Discussion (Misc queries)	3	August 21st 05 01:24 AM

All times are GMT +1. The time now is 08:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us