View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
Posts: 8,651
Default Copying first three characters of text in a cell

Is there any advantage in using MID instead of LEFT?
David Biddulph

wrote in message
Hi Kris,

Use following formula,


H S Shastri

================================================== =
"Kris" wrote:

I need to concatenate text from two cells but only the first three
from one of the cells. Other than subtracting the last 5 characters, is
a simpler way?

A1 is "ABC1"
B1 is "XYZ RSTU"
I need to display in cell C1 this ABC1-XYZ
I've used this formula =A1&"-"&LEFT(B1, LEN(B1)-5)