#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default Excel formula

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Excel formula

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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default Excel formula

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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Excel formula

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Build excel formula using field values as text in the formula val kilbane Excel Worksheet Functions 2 April 18th 07 01:52 PM
Excel Formula Doesn't Execute (Shows formula-not the calcuation) Keys1970 Excel Discussion (Misc queries) 4 November 15th 06 02:12 PM
Excel 2002 formula displayed not value formula option not checked Dean Excel Worksheet Functions 1 February 28th 06 02:31 PM
How do I view formula results intead of formula in excel? davidinatlanta Excel Worksheet Functions 4 February 7th 06 03:02 PM


All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"