Formula to Seperate data in 1 cell

S

Sho

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
If Not blank - Formula for two cells 0
How to summarize copied data 2
Remove punctuation mark, Split cells & average accross column 4
Function to Combine Names and Middle Initital In Various Formats 3
Problem using IF statement with dates as part of the formula 4
Median Formula not working properly 2
Multiple VLOOKUP in an IF statement 2

Top