Reomving a set numer of characters from a text string

[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

 

[Roger Govier]

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.

 

[Bob Phillips]

=LEFT(A1,LEN(A1)-8)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[ado1963]

Thank you both