Lewis_Brown

A huge thanks to ZeroHour, howartp, Ditto & Bedders for their input on this one.

Reverse engineering the user details from an email address [TABLE=align: left] [TR] [TD]A [/TD] [TD]B [/TD] [TD]C [/TD] [TD]D [/TD] [TD]E [/TD] [TD]F [/TD] [/TR] [TR] [TD]Email [/TD] [TD]First Initial [/TD] [TD]Surname [/TD] [TD]Year Group [/TD] [TD]Domain [/TD] [TD]Username [/TD] [/TR] [TR] [TD][email protected] [/TD] [TD]m [/TD] [TD]mouse [/TD] [TD]10 [/TD] [TD]@school.org.uk [/TD] [TD]mmouse10 [/TD] [/TR] [/TABLE] First; F2 =LEFT(A2,FIND("@",A2,1)-1) Then; B2 =LEFT(F2,1) C2 =MID(F2,2,LEN(F2)-3) D2 =RIGHT(F2,2) E2 =RIGHT(A2,LEN(A2)-LEN(F2))

So far, using @ I have; =LEFT(A1) that will report =LEFT(A1, LEN(A1)-17) that will report & =RIGHT(A1,LEN(A1)-FIND("@",A1)) that will report But I don't have anything that will report just or just

Here is a fun question that I need some help with please. I have been asked to find a way to split an existing email address down into its component parts, using Excel. e.g A1 = [email protected] B1 = m C1 = mouse D1 = 10 E1 = @school.co.uk I can create a new email address form the individual parts - just not break one up into its parts. Any help will be most greatly received.

I have been tasked with sourcing an A2 scanner for the Art & Design department at my school, and was wondering if anybody had any recommendations? The scope that I have been given is as follows - It will need to be at least 1200DPI and capable of A3 or bigger scanning. After looking at MANY options, my current favourite is below - ​​but I am open to any suggestions that people may have. [TABLE=width: 1381] [TR] [TD=class: xl67, width: 1381]https://www.plot-it.co.uk/p/contex_iq_flex_a2_flatbed_scanner[/TD] [/TR] [/TABLE] Thanks