Copy & Paste Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to copy and paste a row of numbers but want to cut off the last couple
of digits and then format a certain way. Is this possible?

example: 123456789 copy and paste to new row as 123-456
 
The easiest way is to create a formula like the one below. the copy the
formula down the entire row.

=LEFT(D13,3)&"-"&MID(D13,4,3)

You can convert the formula to text by copy the range of cells and using
paste special with values checked.
 
=TEXT(LEFT(A1,6),"000-000")

if you want these as real numbers use

=--LEFT(A1,6)


and use a custom format of 000-000
 
Back
Top