ExcelBanter - IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function (https://www.excelbanter.com/excel-worksheet-functions/104439-if-function.html)

IF Function

HOW WOULD I GO ABOUT TAKING PART OF A NUMBER STORES AS TEXT IN A CELL
TO AUTOPOPULATE A DIFFERENT CELL? THE CRITERIA IS AS FOLLOWS:

10089 TO CNP
10443 TO TXUED
10032 TO AEP CENTRAL
10202 TO AEP NORTH
10400 TO TNMP

Dav

IF Function

You will have to provide more details. What is part?

Regards

Dav

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=570622

All times are GMT +1. The time now is 10:37 PM.