| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with concatenate formula
=CONCATENATE(A2," ", B2," ", C2," ", G2,CHAR(10),I2," ", J2,
CHAR(10),L2,CHAR(10), M2," ", O2, CHAR(10), P2, CHAR(10), Q2, " ",R2) When I copy this information to a new worksheet, the information just comes out as #REF! and the above formula appears with all #REF! in it. I have the column width wide enough. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE text formula | Excel Worksheet Functions | |||
| I can't get my concatenate formula results to show | Excel Discussion (Misc queries) | |||
| Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
| CONCATENATE formula | Excel Discussion (Misc queries) | |||
| Use numbers in CONCATENATE formula without getting error | Excel Worksheet Functions | |||
Threaded Mode
