DayDay
Board Regular
- Joined
- Jan 30, 2007
- Messages
- 64
Hi all.
Is there a way for me simulate deleting spaces from a list i.e
If a set of formulae has generated a list of results that have multiple/random spaced cells between them like this...
result
result
result
result
without having to use auto-filter or sorting manually can this show in another set of cells as:
result
result
result
result
I hope I am clear, if not please ask me whatever u like.
Thanks as always for any help guys.
David
Is there a way for me simulate deleting spaces from a list i.e
If a set of formulae has generated a list of results that have multiple/random spaced cells between them like this...
result
result
result
result
without having to use auto-filter or sorting manually can this show in another set of cells as:
result
result
result
result
I hope I am clear, if not please ask me whatever u like.
Thanks as always for any help guys.
David