Deleting a consistant portion of all cells in a given column

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

Guest

I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.
 
I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.
Click to expand...

=MID(A2,11,999)

Rick
 
I need to remove only the first 10 characters of 40 character cells in a
=MID(A2,11,999)
Click to expand...

I realize you said all of your text is 40 characters in length which means
you could have used this instead...

=MID(A2,11,30)

but if your text ever got longer, the extra characters from character
position 41 onward would be truncated away. Using a number larger than you
need will protect against your text ever becoming longer. Another
possibility, which automatically protects against longer text being
introduced later on is this formula...

=REPLACE(A4,1,10,"")

Rick
 
Back
Top