HELP: extract certain characters from text string

[sam]

Hi All,

How can I extract First letter from first name, remove the space between
first and last name and keep the last name?

For eg:
I have a list of Names in this format:
John Doe
Will Smith

and I want them like this:
jdoe
wsmith

Thanks in advance

 

[Paul]

Try:

=LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,255)

Assuming A1 holds the text "John Doe". Fill down as many rows a
necessary.

 

[Mike H]

Sam,

Try this and drag down

=LEFT(A2,1)&MID(A2,FIND(" ",A2)+1,999)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[JLGWhiz]

You will have to change the range to your actual, but the rest will run as
is.

Sub dk()
Dim c As Range
For Each c In Range("B2:B7") '<<<change to actual
c.Characters(2, InStr(c, " ") - 1).Delete
Next
End Sub

 

[Otto Moehrbach]

Try this:
=LOWER(LEFT(A1,1)&RIGHT(A1,LEN(A1)-FIND(" ",A1)))
Otto