Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
Hi Bernard
Thanks for your help, i have tried this previously but Excel does not like the first & in the formula any ideas??? "Bernard Liengme" wrote: =A1&" "&B1" -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Beginner2005" wrote in message ... Hi have formula in cell c1{ =a1&b1} which copies the words from both cells and combines them, how do i put a space between the two copied words within this formula please? any help for an amateur greatly appreciated. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |