I'm getting close! I can feel it!
I added a space between the number and the letter 'W'.
I am able to hit shift ctrl enter and have excel turn the formula into an array but it's still displaying "#value".
When I evaluate the formula the Error in Value is "A value used in the formula is of the wrong data type." Is this a formatting issue?
I finally realized I couldn't upload an .xlsm file. I've uploaded a zip file.
Thanks,
Phil
Quote:
Originally Posted by Claus Busch
Hi Phillip,
Am Tue, 27 Sep 2016 18:05:07 +0100 schrieb phillip cole:
How do I ignore anything that follows the 'W' ?
Please see attached spreadsheet that shows a 'value' error when i add a
', C' after the 'W'.
there is still no link.
Insert a space between the number and the text.
Have another look for the workbook at OneDrive
Regards
Claus B.
--
Windows10
Office 2016
|