Posted to microsoft.public.excel.worksheet.functions

MrLarrier

external usenet poster

Posts: 1

Extract a string from a cell

I have a column of data in this format
Lastname, Firstname

I want to extract only the Lastname

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
Extract from string	mark	Excel Discussion (Misc queries)	2	August 8th 06 12:38 PM
Extract certain parts of string	djDaemon	Excel Worksheet Functions	0	February 2nd 06 03:31 PM
Extract sub string	sixbeforedawn	Excel Worksheet Functions	2	October 24th 05 09:50 AM
Extract hyperlink string from excel cell	Ryan Sapien	Links and Linking in Excel	1	January 20th 05 12:24 AM
How do you extract numbers from a string of chacters in a cell (E.	blackbeemer	Excel Worksheet Functions	6	November 12th 04 09:00 AM

All times are GMT +1. The time now is 09:42 AM.

About Us

"It's about Microsoft Excel"