Block part of a column when sending
 

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: http://www.excelforum.com/member.php...o&userid=34534
View this thread: http://www.excelforum.com/showthread...hreadid=542962

Block part of a column when sending
 

"joetcb" wrote in
message ...

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?

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

Block part of a column when sending
 

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: http://www.excelforum.com/member.php...o&userid=34534
View this thread: http://www.excelforum.com/showthread...hreadid=542962

Block part of a column when sending
 

"joetcb" wrote in
message ...

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.

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