Concatenate

From: Paul Falla (paul_falla_at_hotmail.com)
Date: 02/26/04


Date: Thu, 26 Feb 2004 00:41:55 -0800

Dear Manos

In A3 type =LEFT(A1,3) & " " & A2

Hope this Helps

Paul Falla
>-----Original Message-----
>Dear All,
>there is anyway with concatenate, when i am choosing a
>text to format specific characters of this format?
>eg
>A1 -- Actual
>A2 -- 2003
>
>B3 -- to ask "Act 2003"
>
>Thanks in advance,
>Manos
>.
>