Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 10-23-2006, 08:28 AM
cristi22 cristi22 is offline
Nested if formulat to merge cells
Join Date: Oct 2006
Posts: 1
Default Nested if formulat to merge cells

Hello all -

Please help armature excel newly bee! :roll:

Here is my input:

A (file name) B (desc)
------------------ ----------------------------------------------------------
1 ACCOUNTS This file stores the SAC flags per module/process. 2 2 the key to this file varies from
3 a module name, such as ELG, CLM, etc. or can be a
11 ACTIVESUB Store SUB data in adequate format for check
12 printing. Several claim may be grouped into one
15A_TRANS This file contains information which describes
the annuity transaction represented by the key.

A column holds the file name & B is file description. How do I merge the entire description into one line?

The following formula would work for the first two (the number of lines in description field is variable. The separation between the old & the new description line is blank).
So, on the output I should have

----- ------
1ACCOUNTS This file.....
2ACTIVESUB Stores....
3A_TRANS This file .....

Really appreciate your help!
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
format cells to automatically place quotes around text dirtleg Excel 1 09-16-2008 01:52 PM
Nested if formulat to merge cells How to stop correcting zeroes in cells ? kevin_ms Excel 4 09-14-2008 10:08 PM
Nested if formulat to merge cells How to get cells to calculate time? Excel 2 02-09-2007 07:10 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:50 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft