lifeson
10-15-2007, 03:02 AM
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?
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?