Home – New Forums Other discussions Can anyone help me ‘clean up’ an Excel spreadsheet? Reply To: Can anyone help me ‘clean up’ an Excel spreadsheet?

#1070034
Brynn
Member
  • Total posts: 1
Up
0
::

I have had a quick look at the data you posted.

If you replace the formula in cell G3 with this it should work:

=MID(E3,2,(LEN(E3)-2))*D3