software

I need to send some files and in one column is an account # I wish to
only display either the last 4 digits or the 1st 4 digits, is there any
way to do this?
Thanks in advance--
joetcb
------------------------------------------------------------------------
joetcb's Profile: www.excelforum.com/member.php...oamp;userid=34534
View this thread: www.excelforum.com/showthread...hreadid=542962quot;joetcbquot; gt; wrote in
message ...
gt;
gt; I need to send some files and in one column is an account # I wish to
gt; only display either the last 4 digits or the 1st 4 digits, is there any
gt; way to do this?

In another column put =LEFT(A1,4) or =RIGHT(A1,4), then cut this amp; Paste
Special/ Values over the previous column.
--
David Biddulph

David,
Thanks, it gave me the 4 digits that I was looking for but once I
pasted it on the column where the 16 digits were, it took the
information from the previous column and all the numbers disappeared.
If I tried to dlete the 16 digit number than the 4 digits also
disappeared.
So, I will keep searching for a solution
Joe--
joetcb
------------------------------------------------------------------------
joetcb's Profile: www.excelforum.com/member.php...oamp;userid=34534
View this thread: www.excelforum.com/showthread...hreadid=542962quot;joetcbquot; gt; wrote in
message ...
gt;
gt; David,
gt; Thanks, it gave me the 4 digits that I was looking for but once I
gt; pasted it on the column where the 16 digits were, it took the
gt; information from the previous column and all the numbers disappeared.
gt; If I tried to dlete the 16 digit number than the 4 digits also
gt; disappeared.

When you tried to paste it on the column where the original data was, did
you use Paste Special/ Values, as I suggested? It sounds like you just did
a Paste.
--
David Biddulph