Shorten a Text Value

  • Thread starter Thread starter John D O'Connor
  • Start date Start date
J

John D O'Connor

How do I shorten a value displayed in a cell?

I have AB01X but I want to include only the AB01 part in a CONCATENATE
function I've tried ........Text(A1,"2"), thought that might have done it
but no joy

Any ideas

Thanks
 
Thanks Guys


Dave R. said:
If A1 has AB01X,

either
=CONCATENATE(LEFT(A1,4),"text")
or
=LEFT(A1,4)&"text"

but if you want to remove the rightmost character, as opposed to taking only
the left 4 characters, you can use

=LEFT(A1,LEN(A1)-1)
Click to expand...
 
If A1 has AB01X,

either
=CONCATENATE(LEFT(A1,4),"text")
or
=LEFT(A1,4)&"text"

but if you want to remove the rightmost character, as opposed to taking only
the left 4 characters, you can use

=LEFT(A1,LEN(A1)-1)
 
Back
Top