software

Hi,

I have a column with a variable length single text string in each cell
between 9 amp; 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: www.excelforum.com/member.php...oamp;userid=30305
View this thread: www.excelforum.com/showthread...hreadid=499695Hi

You will need to do the splitting into 2 cells.
With data in A1, enter in B1 =IF(LEN(A1lt;9,quot;quot;,LEFT(A1,LEN(A1)-8)
In C1 =IF(LEN(A(lt;9,quot;quot;,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 Specialgt;Values to
convert the cells to hard data in place of the formulae.

--
Regards

Roger Govierquot;ado1963quot; gt; wrote
in message ...
gt;
gt; Hi,
gt;
gt; I have a column with a variable length single text string in each cell
gt; between 9 amp; 36 characters. I want to consistently split or remove the
gt; last (rightmost) 8 characters from this string, and leave the left
gt; part
gt; of the string ( like a reverse concatanation). Is there a function to
gt; do
gt; this?
gt;
gt; Thanks in anticipation.
gt;
gt;
gt; --
gt; ado1963
gt; ------------------------------------------------------------------------
gt; ado1963's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30305
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=499695
gt;
=LEFT(A1,LEN(A1)-8)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;ado1963quot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I have a column with a variable length single text string in each cell
gt; between 9 amp; 36 characters. I want to consistently split or remove the
gt; last (rightmost) 8 characters from this string, and leave the left part
gt; of the string ( like a reverse concatanation). Is there a function to do
gt; this?
gt;
gt; Thanks in anticipation.
gt;
gt;
gt; --
gt; ado1963
gt; ------------------------------------------------------------------------
gt; ado1963's Profile:
www.excelforum.com/member.php...oamp;userid=30305
gt; View this thread: www.excelforum.com/showthread...hreadid=499695
gt;

Thank you both --
ado1963
------------------------------------------------------------------------
ado1963's Profile: www.excelforum.com/member.php...oamp;userid=30305
View this thread: www.excelforum.com/showthread...hreadid=499695