Reomving a set numer of characters from a text string

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
 
R

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.
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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 the last 20 characters out of a text string 4
pulling certain characters from a string of text 3
Pullng data out of string of text 4
Extract from the beginning of a text string 2
Remove characters from a text string using a formula 1
Splitting a cell by number of characters from the end 4
Extract characters from Right of string 5
Replace or insert characters in text string 6

Top