Posted to microsoft.public.excel.worksheet.functions

Heine

external usenet poster

Posts: 49

Spacing problems

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CELL SPACING	scsobgyn	Excel Discussion (Misc queries)	1	September 13th 06 05:24 PM
Double spacing	axissm	Excel Discussion (Misc queries)	2	February 19th 06 11:45 PM
Legend Line Spacing	Bill Sturdevant	Charts and Charting in Excel	1	July 6th 05 12:35 PM
Common spacing	RAJEEV CHADHA	Excel Worksheet Functions	0	April 26th 05 01:29 PM
SPACING	RAJEEV CHADHA	Excel Worksheet Functions	5	April 18th 05 02:11 PM

All times are GMT +1. The time now is 02:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us