Simpler ways to get results?

[Matt Cook]

Hi everyone

I had to manipulate some data today for a boring data entry task. I managed to do what I wanted with what knowledge of Excel I have but I do not know a more efficient way of doing what I wanted, even though I'm 100% positive there will be a more efficient way.
Without using VB what would be some examples of simpler methods?

The info I was given is in Columns A & B
The info I wanted is in Columns G & H

You can see how I got the info

example XL.xlsx
	A	B	C	D	E	F	G	H
1	Matt	Smith	matt	smith	Mattsmith	Mattsm	Mattsm!35	matt.smith.app
2	Mark	Jones	mark	jones	Markjones	Markjo	Markjo!35	mark.jones.app
3	Jeremy	Crooks	jeremy	crooks	Jeremycrooks	Jeremy	Jeremy!35	jeremy.crooks.app
4	Susan	Harrison	susan	harrison	Susanharrison	Susanh	Susanh!35	susan.harrison.app
Sheet1

Cell Formulas
Range	Formula
C1:D4	C1	=LOWER(A1)
E1:E4	E1	=TEXTJOIN(,TRUE,A1,D1)
F1:F4	F1	=LEFT(E1,6)
G1:G4	G1	=TEXTJOIN(,TRUE,F1,"!35")
H1:H4	H1	=TEXTJOIN(".",TRUE,C1,D1,"app")

Thanks in advance for any time that's taken up replying to my question.

 

[NateSC]

I often split it into separate pieces like your example and then put it all together in the end. Also, I typically use "&" to put strings together so I came up with:

temp macro work.xlsm
	A	B	C	D
1	Matt	Smith	Mattsm!35	matt.smith.app
2	Mark	Jones	Markjo!35	mark.jones.app
3	Jeremy	Crooks	Jeremy!35	jeremy.crooks.app
4	Susan	Harrison	Susanh!35	susan.harrison.app
Sheet9

Cell Formulas
Range	Formula
C1:C4	C1	=LEFT(A1&LOWER(B1),6)&"!35"
D1:D4	D1	=LOWER(A1 & "."&B1&".app")

 

[Matt Cook]

I often split it into separate pieces like your example and then put it all together in the end. Also, I typically use "&" to put strings together so I came up with:

temp macro work.xlsm
	A	B	C	D
1	Matt	Smith	Mattsm!35	matt.smith.app
2	Mark	Jones	Markjo!35	mark.jones.app
3	Jeremy	Crooks	Jeremy!35	jeremy.crooks.app
4	Susan	Harrison	Susanh!35	susan.harrison.app
Sheet9

Cell Formulas
Range	Formula
C1:C4	C1	=LEFT(A1&LOWER(B1),6)&"!35"
D1:D4	D1	=LOWER(A1 & "."&B1&".app")

Ahhhhh

I have written that example down as I'm 100% sure I'll need it in the future.

That is exactly what I was looking for thank you.