Posted to microsoft.public.excel.programming

tom[_7_]

external usenet poster

Posts: 24

Remove ' if not followed by two digits

Hi -

I'd like a quick formula that will remove an apostrophe if the
apostrophe is not followed by two digits. Ex:

Original Desired Result
Abe '89 Abe '89
Bye '88 Bye '88
Chie ' Chie
Lead '64 Lead '64
Foloow ' Foloow

What is the quickest way to do this? I'm struggling with
=LEFT(A2,FIND("'",A2) . . .

Thanks for your help.

-Tom

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 all but the last seven digits in a cell	Gary Crisp	Excel Discussion (Misc queries)	10	February 12th 08 07:59 PM
Formula amendment to not remove digits	Sarah (OGI)	Excel Worksheet Functions	3	August 20th 07 04:42 PM
Remove first few digits from all cells in the column	Magwine	Excel Worksheet Functions	7	August 2nd 07 10:39 PM
remove and replace digits from a number	spreadsheet monkey	Excel Worksheet Functions	3	April 20th 07 02:08 PM
Excel 2002 : How to remove the digits from original reference ?	Mr. Low	Excel Discussion (Misc queries)	6	April 13th 07 02:04 PM

All times are GMT +1. The time now is 09:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us