ExcelBanter - Formula for Extracting Alphabetic Part of a Product Code

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

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

- - Formula for Extracting Alphabetic Part of a Product Code (https://www.excelbanter.com/excel-worksheet-functions/5331-formula-extracting-alphabetic-part-product-code.html)

ob3ron02

Formula for Extracting Alphabetic Part of a Product Code

Frank, this formula gives me the #VALUE! error.

--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=273584

Frank Kabel

Hi
have you entered it as array formula with CTRL+SHIFT+ENTER?

--
Regards
Frank Kabel
Frankfurt, Germany

ob3ron02 wrote:
Frank, this formula gives me the #VALUE! error.

All times are GMT +1. The time now is 03:48 AM.