Thank you for your help!!!!!

Roger Govier wrote:
Hi

Try
=IF(LEFT(A1,2)="23",MID(A1,3,10),A1)
If you want these values to display as numbers then precede the whole
formula with the double unary minus, which will coerce the result from
Text to Numeric

=--(IF(LEFT(A1,2)="23",MID(A1,3,10),A1))

In a column of numbers, SOME cell of numbers START WITH "23", I need
to
[quoted text clipped - 7 lines]
Example: 231234567890 (Numbers Imported into Excel as TEXT Format)
Need To Look Like This: 1234567890

--
Thank you for your help!!!! Have a GREAT DAY!!!!