Link to home
Create AccountLog in
Avatar of Rickzzz

asked on

Excel - Parse Column Text

cell a1 =

I just need the "user" part prior to the @ in another column.

Thanks in advance!
Avatar of Professor J
Professor J

two option , first option use text to column

go to data tab then text to column

then your delimited and on the selection unmark all mark "other"  then put @ in that small box and then next and finish.

second Option
if you want to use formula instead of text2column then .  lets say your data starts from cell A2 then put in B2  =TRIM(MID(SUBSTITUTE(A2,"@",REPT(" ",99)),1*99-98,99))  and in C2   =TRIM(MID(SUBSTITUTE(A2,"@",REPT(" ",99)),2*99-98,99)) and drag the formula down
Avatar of sj_rodriguez
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
if you just need the first part before @  then you only use this =TRIM(MID(SUBSTITUTE(A1,"@",REPT(" ",99)),1*99-98,99))
Avatar of Rickzzz


Perfect, thanks.