Block part of a column when sending

J

joetcb

I need to send some files and in one column is an account # I wish t
only display either the last 4 digits or the 1st 4 digits, is there an
way to do this?
Thanks in advanc
 
D

David Biddulph

joetcb said:
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?
Click to expand...

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

joetcb

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
 
D

David Biddulph

joetcb said:
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.
Click to expand...

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.
 
Top