Posted to microsoft.public.excel.misc

MikeL

external usenet poster

Posts: 14

Removing character in a string

When importing an excel file the character " ' " appears in front of a zip
code;

'85004 this hinders the vlookup formula. How can I remove this character en
mass?

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
Removing a character	sjs	Excel Worksheet Functions	4	November 14th 07 09:29 PM
Excel-Match 1st text character in a string to a known character?	bushlite	Excel Worksheet Functions	2	January 15th 07 06:36 PM
Removing last character in a cell	John Bundy	Excel Worksheet Functions	0	November 30th 06 06:32 PM
Removing last character in a cell	Megadrone	Excel Worksheet Functions	0	November 30th 06 06:23 PM
NEED HELP-----Removing a space at the end of a string of character	FRS	Excel Discussion (Misc queries)	7	April 13th 06 03:57 AM

All times are GMT +1. The time now is 07:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us