Solved: Create short name

[lifeson]

How can I create a short name from a first name and surname:

e.g

In row 1
column A: "Alex Lifeson"
I want to create "A Lifeson" in column B


I have 100s to change so some sort of formula that trims a text string upto a space is what I am looking for if such a thing is available?

[CCkfm2000]

try this in cell b1

=LEFT(A1,1)&" "&RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

[lifeson]

try this in cell b1

=LEFT(A1,1)&" "&RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

:friends: :thumb
Spot on
Thanks