Hi there!
Question regarding a cell lookup that returns a truncated value. I am working in an excel 2003 file (needs to stay in this format for the end user). I have the following function
=IF(AY2="","blank",LEFT(AY2,9))
The main information I want is the first 9 characer in AY2 if there are values there. The AY column could have any number of characters but I always want the first 9. All had been going well when I ran into the value
<TABLE style="WIDTH: 173pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=230><COLGROUP><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 6542" width=230><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 173pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20 width=230 align=right>433892720000082000000000</TD></TR></TBODY></TABLE>
Because of the length it truncates it to
4.3389272
This gives me the wrong number
I need it to return
433892720
Any guidance is appreciated!
Thanks
Question regarding a cell lookup that returns a truncated value. I am working in an excel 2003 file (needs to stay in this format for the end user). I have the following function
=IF(AY2="","blank",LEFT(AY2,9))
The main information I want is the first 9 characer in AY2 if there are values there. The AY column could have any number of characters but I always want the first 9. All had been going well when I ran into the value
<TABLE style="WIDTH: 173pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=230><COLGROUP><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 6542" width=230><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 173pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=20 width=230 align=right>433892720000082000000000</TD></TR></TBODY></TABLE>
Because of the length it truncates it to
4.3389272
This gives me the wrong number
I need it to return
433892720
Any guidance is appreciated!
Thanks