On 6 Mar., 11:11, Mike wrote:
With number in A1 try

=RIGHT(TRIM(SUBSTITUTE(A1,CHAR(32),"")),4)

Mike



"Heine" wrote:
Hello everybody,

I am importing a phonelist via a web query. my phone numbers look like
this when imported:

11 22 33 44

I want to remove the spaces and only return the last four digits - how
is this done most easily?

Is it possible to Vlookup in a web query qithout problems?

Thanks in advance.

Regards
Heine- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -

Thanks Mike - that works great. Now I want to lookup in my query. Why
does it return #N/A? If I copy and insert values it does work. But
then I do not get the automation.... Hope somebody can help solve
this.

Regards
Heine