FORMULAE - REPLACE

D

DarkStar

How do I replace the first name with the first initial from a list of first
an d last names?

e.g.

John Doe with J Doe

Thank you,
 
R

Rick Rothstein \(MVP - VB\)

Here is another way...

=SUBSTITUTE(A1,MID(A1,2,FIND(" ",A1)-2),"")

Rick
 
R

Ron Rosenfeld

How do I replace the first name with the first initial from a list of first
an d last names?

e.g.

John Doe with J Doe

Thank you,
Click to expand...


=REPLACE(A1,2,FIND(" ",A1)-2,"")

If it is possible that either the first or last name is not properly
capitalized, you could use this to also capitalize properly:

=PROPER(REPLACE(A1,2,FIND(" ",A1)-2,""))

--ron
 

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

Reversing order of text 2
complicated text to column 4
Simple question on Sorting 5
LAST, FIRST to First Last 4
alpha numeric sorting 2
Edit/Replace to seperate text in columns 3
SUMIF & IF 5
How to join row data into one row 1

Top