Hi there i have tried

= LEFT(A1,3) & " " & RIGHT(A1,3

and it does not work.


I have excel 2008 mac.

Is that wy?

and what can i do.

Please help its urgent

Well, you have missed a bracket off the end of the formula:

= LEFT(A1,3) & " " & RIGHT(A1,3)

but I would have expected Excel to suggest that to you.

Hope this helps.

Pete

On Aug 19, 1:43*am, ddvuilla...@gmail.com wrote:
> Hi there i have tried
>
> = LEFT(A1,3) & " *" & RIGHT(A1,3
>
> and it does not work.
>
> I have excel 2008 mac.
>
> Is that wy?
>
> and what can i do.
>
> Please help its urgent

I'll assume the missing closing parenthesis at the end of the line you
posted is a typo; so, describe "does not work" for us... what do you have,
what did you expect to happen, what actually happened instead?

Rick


<(E-Mail Removed)> wrote in message
news:b8d6f014-e2a9-4bd8-95e1-(E-Mail Removed)...
> Hi there i have tried
>
> = LEFT(A1,3) & " " & RIGHT(A1,3
>
> and it does not work.
>
>
> I have excel 2008 mac.
>
> Is that wy?
>
> and what can i do.
>
> Please help its urgent