steve the excel guy
Board Regular
- Joined
- Aug 28, 2007
- Messages
- 104
I want a formula in one cell that will include all the data from other cells including blanks like so:
A1 A2 A3 A4 A5
1 2 4 5
In the above example, there is one number in each cell except for A3.
I want a formula in B1 that will return "12 45" based on the above scenario. In my current arrangement, it will only produce "1245" with no spaces.
I'm sure it's a simple solution but I can't figure it out. Please help!!
A1 A2 A3 A4 A5
1 2 4 5
In the above example, there is one number in each cell except for A3.
I want a formula in B1 that will return "12 45" based on the above scenario. In my current arrangement, it will only produce "1245" with no spaces.
I'm sure it's a simple solution but I can't figure it out. Please help!!