How to separate data from one cell !!

[SlavOK400]

I've got a small problem*
There is some data i need to separate into 3 columns: Name, Hashtag and all that goes after the hashtag. So the data from A1 cell will be like (Finn Harries),(@FinnHarry ), (New York Good design) separately in 3 columns.


StartFragment
*(A1) Finn Harries @FinnHarry New York Good design.
*(A2) Tumblr @tumblr New York CityFollow the world’s creators.*
(A3) Joan Rivers @Joan_Rivers New York City, New York
(A4) Andrea Pirlo @Pirlo_official Nato a Flero (BS) il 19 Maggio*

For the first column i used*=LEFT(A1,FIND(" @",A1)-1) formula. Please help me with the other two !! i spend hours trying to do that.

[FDibbins]

I get the 1st split - at the @ sign
I dont get where the 2nd/3rd comes?

(have you tried Text2Columns for this?)

[FDibbins]

hmm maybe this?

	A	B	C	D
1	Finn Harries @FinnHarry New York Good design.	Finn Harries	@FinnHarry	New York Good design.
2	Tumblr @tumblr New York CityFollow the world’s creators.*	Tumblr	@tumblr	New York CityFollow the world’s creators.*
3	Joan Rivers @Joan_Rivers New York City, New York	Joan Rivers	@Joan_Rivers	New York City, New York
4	Andrea Pirlo @Pirlo_official Nato a Flero (BS) il 19 Maggio*	Andrea Pirlo	@Pirlo_official	Nato a Flero (BS) il 19 Maggio*

B1=LEFT(A1,FIND("@",A1,1)-2)
C1=LEFT(TRIM(SUBSTITUTE(A1,B1,"")),FIND(" ",TRIM(SUBSTITUTE(A1,B1,""))))
D1=MID(A1,FIND(C1,A1,1)+LEN(C1),99)
all copied down

[SlavOK400]

You are genius. Thank you so much !

[FDibbins]

haha not really, but thanks, I am happy to help, and thanks for the feedback