Truncating the leading information

[starkmanuk]

Hi all,

I currently have a Excel Sheet, that looks similar to this,

Name | Tel | Divison | Email | ShortName | Mail Server

On the Tel field, the information populated from a Lotus notes DB appears as follows:

<TABLE style="WIDTH: 141pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=188 border=0><COLGROUP><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" width=188><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 141pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=188 height=20>(cell) 0700000000 - Obviously the number has changed.

I've been looking for a way of an automatic truncating (i believe thats the right word) the first 8 characters so i'm left with just the number that can be easily uploaded to other mobile devices.

i've searched these forums and in the past have never needed to register as the answer was already there! Tho i should of registered to say thanks!

Please can anyone help regarding this?


Many Thanks,
Dave
</TD></TR></TBODY></TABLE>

 

[sanrv1f]

not sure why you need to remove 8 chars, when "(cell) " is only 7 chars

try

=RIGHT(B2,LEN(B2)-8)

 

[starkmanuk]

Thank you...

I was removing 8 Characters as there is (char) and 2 black spaces inbetween!

Thanks Again!