|
|
|
|
#1
04-03-2020, 08:49 AM
|
||||
|
||||
That looked right to me at first, but on second thought doesn't it just provide the last two digits? That is, if A1 has "6677889900", your formula will return not "6677889905" (which is what I suppose the OP wants) but just "05".
Pretty close, though; easy enough to fix it: Code:
=LEFT(A1,8)&SUBSTITUTE(RIGHT(A1,2),"00","05") 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| long digit error | Midasbelize | Excel | 1 | 05-16-2017 10:14 AM |
| Changing Distance Between a Digit and it's Subscript | mohsen.amiri | Word | 2 | 01-22-2017 12:59 AM |
| Selecting a digit from a code | Warren99 | Excel | 2 | 05-29-2016 04:08 AM |
| Regex/wildcard search for dates with 2-digit and 4-digit years | Marrick13 | Word VBA | 2 | 01-29-2016 07:04 AM |
 A challenging digit by digit manipulation, rotate the digit in range of 0 to 9
|
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode