Drop the first 4 digits from a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hoganc - 05 Oct 2004 10:27 GMT

How do I remove the first four no.s in a Column ie

C803/C803/2296

I would like the column or a new column to drop the first C803/ and ad
an

Reply to this Message

Frank Kabel - 05 Oct 2004 10:36 GMT

Hi
use
="E" & MID(A1,5,255)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> How do I remove the first four no.s in a Column ie
>
> C803/C803/2296
>
> I would like the column or a new column to drop the first C803/ and

add

> an E
>
[quoted text clipped - 3 lines]
> hoganc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14980
> View this thread: http://www.excelforum.com/showthread.php?threadid=266364

Reply to this Message