PLACE TEXT RIGHT: place a character to the right in same place

[itr674]

I am trying to put asingle text character al the way right when using "courier new" itlines up in he same place.

The setup is:
Name cell: Last, First
Group cell: can be character two, three, or fourcharacters, and will be listed first

Using FIND to get just the LEN of Last nameand comma

Example of what Iwould like it to look like.

ABCD Last Name x
ABC Last Name x
AB LastName x

 

[Fluff]

Is this what you mean

Book1
	A	B	C	D
2	ABCD	Mary	x	ABCD Mary x
3	ABC	Mungo	x	ABC Mungo x
4	AB	Midge	x	AB Midge x
Sheet2

Cell Formulas
Range	Formula
D2	=REPLACE(REPT(" ",10),1,LEN(A2),A2)&REPLACE(REPT(" ",10),1,LEN(B2),B2)&C2

PS:
It doesn't look as though it's lined up, but it will be in the sheet.

 

[itr674]

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback

 

[Peter_SSs]

If interested, here is a shorter version that I think should still do the job.

Excel Workbook
	A	B	C	D
2	ABCD	Mary	x	ABCDMaryx
3	ABC	Mungo	x	ABCMungox
4	AB	Midge	x	ABMidgex
Align

 

[Rick Rothstein]

If interested, here is a shorter version that I think should still do the job.

And here is another one that is way, way shorter.

=REPLACE(A2&REPT(" ",20-LEN(A2))&C2,11,LEN(B2),B2)

 

[Peter_SSs]

And here is another one that is way, way shorter.

In that case, what about?

=LEFT(REPLACE(A2&REPT(" ",20),11,1,B2),20)&C2

 

[Rick Rothstein]

In that case, what about?

=LEFT(REPLACE(A2&REPT(" ",20),11,1,B2),20)&C2

So why didn't you post that in the first place?

 

[Peter_SSs]

So why didn't you post that in the first place?

I needed to trick you into entering.