#### steve the excel guy

##### Board Regular

- Joined
- Aug 28, 2007

- Messages
- 104

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!!