Hey Guys,
Looking to see if anyone can help me with a formula I am struggling with.
In my excel sheet I am trying to change "Full Name" in A1 ie. "John Smith" to "JohnS" in b1.
Using =LEFT(A1,FIND(" ",A1,1)+1) in B1 gives the result "John S"
But for the life of my I can not remove the space, I have tried using SUBSTITUTE(" ","") along with TRIM but formula is just failing where ever i try to add it.
I current have this ATM which is not working..
=LEFT(A2,FIND(" ",A2,1)+1,substitute(" ",""))
Any help would be greatly appreciated
Dickie
Looking to see if anyone can help me with a formula I am struggling with.
In my excel sheet I am trying to change "Full Name" in A1 ie. "John Smith" to "JohnS" in b1.
Using =LEFT(A1,FIND(" ",A1,1)+1) in B1 gives the result "John S"
But for the life of my I can not remove the space, I have tried using SUBSTITUTE(" ","") along with TRIM but formula is just failing where ever i try to add it.
I current have this ATM which is not working..
=LEFT(A2,FIND(" ",A2,1)+1,substitute(" ",""))
Any help would be greatly appreciated
Dickie
