Full Text
You can split the cells by following these steps: -Select column A -From the top menu, select Data and then Text to Columns -Select Delimited and click Next -Under the Delimiters heading, make sure only Space is selected and click Next -Under the Destination area, type $B$1 and then click Finish You can split the login from the domain in an email with: =left(A1,find("@",A1)-1) How do I take the first character of 1 cell and prepend it to another cell and place it in a 3rd cell? =CONCATENATE(LEFT(A1,1), B1)