Real particles are never completely localised in space (except possibly in the limit case of a completely undefined momentum), due to the uncertainty principle. Rather, they are necessarily in a superposition of a continuum of position and momentum eigenstates.
Pauli's Exclusion Principle asserts that they cannot be in the same exact quantum state, but a direct consequence of this is that they tend to also not be in similar states.
This amounts to an effective repulsive effect between particles.
You can see this by remembering that to get a physical two-fermion wavefunction you have to antisymmetrize it.
This means that if the two single wavefunctions are similar in a region, the total two-fermion wavefunction will have nearly zero probability amplitude in that region, thus resulting in an effective repulsive effect.
To see this more clearly, consider the simple 1-dimensional case, with two fermionic particles with partially overlapping wavefunctions.
Let's call the wavefunctions of the first and second particles $\psi_A(x)$ and $\psi_B(x)$, respectively, and let us assume that their probability distributions have the form:
The properly antisymmetrized wavefunction of the two fermions will be given by:
$$
\Psi(x_1,x_2) = \frac{1}{\sqrt2}\left[ \psi_A(x_1) \psi_B(x_2)- \psi_A(x_2) \psi_B(x_1) \right].
$$
For any pair of values $x_1$ and $x_2$, $\lvert\Psi(x_1,x_2)\rvert^2$ gives the probability of finding one particle in the position $x_1$ and the other particle in the position $x_2$.
Plotting $\lvert\Psi(x_1,x_2)\rvert^2$ we get the following:
As you can clearly see from the picture, for $x_1=x_2$ the probability vanishes. This is an immediate consequence of Pauli's exclusion principle: you cannot find the two identical fermions in the same position state.
But you also see that, the more $x_1$ is close to $x_2$, the smaller is the probability, as it must be due to continuity of the wavefunction.
Addendum: Can the effect of Pauli's exclusion principle be thought of as a force in the conventional $F=ma$ sense?
The QM version of what is meant by force in the classical setting is an interaction mediated by some potential, like the electromagnetic interaction between electrons.
This corresponds to additional terms in the Hamiltonian, which says that certain states (say, same charges very close together) correspond to high-energy states and are therefore harder to reach, and vice versa for low-energy states.
Pauli's exclusion principle is conceptually entirely different: it is not due to an increase of energy associated with identical fermions being close together, and there is no term in the Hamiltonian that mediates such "interaction" (important caveat here: this "exchange forces" can be approximated to a certain degree as "regular" forces).
Rather, it comes from the inherently different statistics of many-fermion states: it is not that identical fermions cannot be in the same state/position because there is a repulsive force preventing it, but rather that there is no physical (many-body) state associated with them being in the same state/position.
There simply isn't: it's not something compatible with the physical reality described by quantum mechanics.
We naively think of such states because we are used to reasoning classically, and cannot wrap our heads around what the concept of "identical particles" really means.
Ok, but what about things like degeneracy pressure then?
In some circumstances, like in dying stars, Pauli's exclusion principle really seems to behave like a force in the conventional sense, contrasting the gravitational force and preventing white dwarves from collapsing into a point.
How do we reconcile the above described "statistical effect" with this?
What I think is a good way of thinking about this is the following:
you are trying to squish a lot of fermions into the same place.
However, Pauli's principle dictates a vanishing probability of any pair of them occupying the same position.
The only way to reconcile these two things is that the position distribution of any fermion (say, the $i$-th fermion) must be extremely localised at a point (call it $x_i$), different from all the other points occupied by the other fermions.
It is important to note that I just cheated for the sake of clarity here: you cannot talk of any fermion as having an individual identity: any fermion will be very strictly confined in all the $x_i$ positions, provided that all the other fermions are not.
The net effect of all this is that the properly antisymmetrized wavefunction of the whole system will be a superposition of lots of very sharp peaks in the high dimensional position space.
And it is at this point that Heisenberg's uncertainty comes into play: very peaked distribution in position means very broad distribution in the momentum, which means very high energy, which means that the more you want to squish the fermions together, the more energy you need to provide (that is, classical speaking, the harder you have to "push" them together).
To summarize: due to Pauli's principle the fermions try so hard to not occupy the same positions, that the resulting many-fermion wavefunction describing the joint probabities becomes very peaked, highly increasing the kinetic energy of the state, thus making such states "harder" to reach.
Here (and links therein) is another question discussing this point.