LEFT ampersand RIGHT Is not working in a sheet, It used to work.!

[david gonzalez]

Hi Dear forums Expert !

well, this is the problem :

Let say that In G5 I have an String 05-12-07-28-02-17-26-31-13-33-11-27-16-29-32
NOTE:
-.String not always have the same amount of Numbers, Sometimes are 12, others times are 16, some other 14, etc,etc
-.Sheet is clean, it doesn't have any VB macro.

From that String I need to extract 8 numbers In different ways, as Follow:

First 8 numbers
First 7 numbers, and Last 1 Number.
First 6 numbers, and Last 2 Numbers
First 5 numbers, and Last 3 Numbers
etc

Then i applied The LEFT, RIGHT Formula

Please Login or Register  to view this content.

But i dont get the 8 numbers as desire, this is what i getting:


05-12-07-28-02-17-26-31
05-12-07-28-02-17-26
05-12-07-28-02-17
05-12-07-28-02


please, can i have some help, i don't know what i'm doing wrong..

[martindwilson]

what does just =right(g5,3) return?
have you tried
=LEFT(trim(G5),20)&RIGHT(trim(G5),3)

[david gonzalez]

Hi Mr Martindwilson,

It worked with the "trim",

Thank you !

but i'm still thinking why no work the "left&right"
i tried in another sheet and the left+right with the ampersand work
but not on this other sheet.

Again, Thank you so much !!!

[martindwilson]

if it didnt work without trim() then you have trailing spaces after the string,trim() simply removes them