Reomving a set numer of characters from a text string

  • Thread starter Thread starter ado1963
  • Start date Start date
A

ado1963

Hi,

I have a column with a variable length single text string in each cel
between 9 & 36 characters. I want to consistently split or remove th
last (rightmost) 8 characters from this string, and leave the left par
of the string ( like a reverse concatanation). Is there a function to d
this?

Thanks in anticipation
 
Hi

You will need to do the splitting into 2 cells.
With data in A1, enter in B1 =IF(LEN(A1<9,"",LEFT(A1,LEN(A1)-8)
In C1 =IF(LEN(A(<9,"",RIGHT(A1,8))

If you want to delete the original column A, then first you would need
to copy the complete range of cells in B:C and Paste Special>Values to
convert the cells to hard data in place of the formulae.
 
=LEFT(A1,LEN(A1)-8)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top