Inserting space between merged text

K

Kristine

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!
 
R

Ron de Bruin

Use this Kristine

=A1& " " & B1

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




Kristine said:
Is it possible to automatically have a space inserted between merged text after using the Concatenate formula so that data
Click to expand...
come out as Mark Jones instead of MarkJones?
 
G

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
Click to expand...
between merged text after using the Concatenate formula
so that data come out as Mark Jones instead of MarkJones?
 
A

Angie

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