Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove ' if not followed by two digits
Tom,
For a value in cell A1: =IF(ISERROR(VALUE(MID(A1,FIND("'",A1)+1,2))),TRIM( SUBSTITUTE(A1,"'","")),A1) HTH, Bernie MS Excel MVP "tom" wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove ' if not followed by two digits
Will smarties never cease to amaze me?
Thank you for your help - you're awesome. -tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove all but the last seven digits in a cell | Excel Discussion (Misc queries) | |||
Formula amendment to not remove digits | Excel Worksheet Functions | |||
Remove first few digits from all cells in the column | Excel Worksheet Functions | |||
remove and replace digits from a number | Excel Worksheet Functions | |||
Excel 2002 : How to remove the digits from original reference ? | Excel Discussion (Misc queries) |