Posted to microsoft.public.excel.misc

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Picking out certain data from a cell

Hi Jade,

Am Wed, 9 May 2012 08:32:06 +0000 schrieb jade89:

#01-034 EAST AVENUE

the string in A1, then try:
=LEFT(A1,FIND(" ",A1)-1)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
How to I create picking another sheet data with 2 different cell	DC	Excel Worksheet Functions	1	March 11th 08 04:27 PM
picking some data from a column	guenter	Excel Programming	2	July 26th 05 03:43 PM
Picking data	Tudor	Excel Worksheet Functions	2	June 14th 05 11:16 AM
picking data	axg275	Excel Programming	0	August 7th 04 07:44 PM
Picking data from another workbook	jdcollins21[_2_]	Excel Programming	2	November 19th 03 09:02 PM

All times are GMT +1. The time now is 09:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us