Cut and Paste

G

Guest

I have a large column of cells. I would like to cut and paste the first five
digits of each of the cells in this column, without cutting and pasting the
remaining cell info. How is this done?
 
G

Guest

Hi,
Use a helper column (say Column B)
In b1 put the following formula = left(a1,5)
copy that cell all the way down to where your data ends in column a
Then highlight column B and paste special - values to whereever you want
them pasted
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent Cut and Paste 3
Cut last row and paste elsewhere 1
Copy/Paste Doesn't Carry Formats 2
Cut & Paste in Excel without erasing cell borders? 1
Disable cut and paste 2
CONCATENATE 3
Cut & Paste 1
Protecting is NOT working right !!!!!!!!!!!!!! 6

Top