Formula to Seperate data in 1 cell

JBoulton

Posts: n/a

This should do it for you.

=RIGHT(A1,LEN(A1)-FIND(".",A1))

"Sho" wrote:

I have names on a sheet that I am trying to separate e.g. John.Smith

If I do the formula = Left(A1,Find(".",A1)-1) it returns John in the cell
which is correct however if I do the formula Right(A1,Find(".",A1)-1) it
works on some names and not others. Any idea of a formula where I can just
extract the surname?

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 do I make a formula NOT change when the data range is moved?	Alida Andrews	Excel Discussion (Misc queries)	2	January 6th 05 09:02 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM
Formula for copying data for every 8th cell	jbsand1001	Setting up and Configuration of Excel	5	January 4th 05 02:08 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula?	Arvi Laanemets	Excel Discussion (Misc queries)	0	December 2nd 04 11:29 AM
How to populate column with formula based on value in cell	Cameron Stewart	Excel Worksheet Functions	2	November 2nd 04 01:36 AM

All times are GMT +1. The time now is 01:00 PM.

Menu

About Us