| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
space before cell contents
Hi
Had a look in previous threads to no avail I have post codes in cells across page A1 CV B1 35 C1 oRR I got CV35 in cell D1 by =A1&B1, but when added &C1 did not get the space beween the "V" and "0" how do I get CV35 0RR (with the space)? Any help appriciated regards Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200802/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
| Merge contents of cells and insert line space | Excel Worksheet Functions | |||
| If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
