Cut and Paste

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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

Cut & Paste in Excel without erasing cell borders? 1
Cut last row and paste elsewhere 1
CONCATENATE 3
Is there a one button shortcut for "copy cell above & paste here" 4
Paste Delimited 8
Protecting is NOT working right !!!!!!!!!!!!!! 6
Copy/Paste Doesn't Carry Formats 2
Disable cut and paste 2

Back
Top