Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2006, 08:28 AM
cristi22 cristi22 is offline
Novice
Nested if formulat to merge cells
 
Join Date: Oct 2006
Posts: 1
cristi22
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
4
5
9
10
11 ACTIVESUB Store SUB data in adequate format for check
12 printing. Several claim may be grouped into one
13
14
15A_TRANS This file contains information which describes
the annuity transaction represented by the key.


Code:
=IF(ISTEXT(A1),B1&B2,"")
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

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

Really appreciate your help!
Reply With Quote
Reply

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? jrasche2003@yahoo.com 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:15 AM.


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