I know of no formula(s) to identify the cells needed to be deleted.......
You might do it by hand, with the assistance of this little macro.....
Just highlight the cells you wish to delete, and press Ctrl-z to fire the
macro...

Sub DeleteSelection()
' Keyboard Shortcut: Ctrl+z
Selection.Delete Shift:=xlUp
End Sub


Vaya con Dios,
Chuck, CABGx3


"Peggy" wrote:

Hi Thanks for your reply. Unfortunatley, it's not as easy as concatenating
the cells. I will try and lay out what it looks like:
a b c d e
1[text]
2[text]
3 [text] [text]
4 [text] [text
5 [text] [text]
6 [text] [text]
7 [text] [text]

What I was wondering if there is a formula that I can used to delete the
spaces in cells a3, a4, a6, a7, c3 & C4 so the information in the other cells
is aligned properly so it's easier to read. Can this be done?!!

Thanks,
Peggy

"CLR" wrote:

If the differences are consistant, you might use.........

=CONCATENATE(A1,B2,B4,C3,C5)

Vaya con Dios,
Chuck, CABGx3



"Peggy" wrote:

Is there a formula I can use to format data? I have a spreadsheet that is
saved from a database but the data ends up in different columns and I have to
fiddle with it to align everything just right. For example on piece of data
will be in cell a1, the next piece will be in b2, then b4, then c3 and c5.
Is there a code that will remove empty cells?