Inserting space between merged text

[Guest]

Is it possible to automatically have a space inserted between merged text after using the Concatenate formula so that data come out as Mark Jones instead of MarkJones

Perhaps there is something I can insert in the formula, or maybe a macro

Thanks!

 

[Ron de Bruin]

Use this Kristine

=A1& " " & B1

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

Is it possible to automatically have a space inserted between merged text after using the Concatenate formula so that data

come out as Mark Jones instead of MarkJones?

 

[Guest]

Just put a space in for one of the concatenate text boxes
[function wizard]. It will update the formula to look
like " " or you can just add it in the formula directly,
like CONCATENATE(TEXT1," ",TEXT2). Result = TEXT1 TEXT2

-----Original Message-----
Is it possible to automatically have a space inserted

between merged text after using the Concatenate formula
so that data come out as Mark Jones instead of MarkJones?

 

[Guest]

Thank you for this. I have been racking my brain, trying to figure this out for hours. You are great!