Hi,

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

Thanks in anticipation.


--
ado1963
------------------------------------------------------------------------
ado1963's Profile: http://www.excelforum.com/member.php...o&userid=30305
View this thread: http://www.excelforum.com/showthread...hreadid=499695

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 SpecialValues to
convert the cells to hard data in place of the formulae.

--
Regards

Roger Govier


"ado1963" wrote
in message ...

Hi,

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

Thanks in anticipation.


--
ado1963
------------------------------------------------------------------------
ado1963's Profile:
http://www.excelforum.com/member.php...o&userid=30305
View this thread:
http://www.excelforum.com/showthread...hreadid=499695

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ado1963" wrote in
message ...

Hi,

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

Thanks in anticipation.


--
ado1963
------------------------------------------------------------------------
ado1963's Profile:
http://www.excelforum.com/member.php...o&userid=30305
View this thread: http://www.excelforum.com/showthread...hreadid=499695

Thank you both :)


--
ado1963
------------------------------------------------------------------------
ado1963's Profile: http://www.excelforum.com/member.php...o&userid=30305
View this thread: http://www.excelforum.com/showthread...hreadid=499695