Reomving a set numer of characters from a text string

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.

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.

--
Regards

Roger Govier


"ado1963" <[email protected]> wrote
in message news:[email protected]...
>
> 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" <[email protected]> wrote in
message news:[email protected]...
>
> 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