Spacing problems
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
|