Separate the first few characters out of the cell.

[jamesw81]

Hi , I have a list in A column which starts...
'1. Testword I want that list repeated in B column but.without the first four characters. I just want the letters. How do I right a formula for this. Thanks

 

[jtakw]

Hi,

A couple of ways:

Book3.xlsx
	A	B	C
1	1. Testword	Testword	Testword
2	2. Testword	Testword	Testword
3	12. Testword	Testword	Testword
4	112. Testword	Testword	Testword
Sheet935

Cell Formulas
Range	Formula
B1:B4	B1	=MID(A1,FIND(".",A1)+2,255)
C1:C4	C1	=MID(A1,FIND(" ",A1)+1,255)

 

[Fluff]

Hi & welcome to MrExcel.

How about

=replace(a2,1,find(" ",a2),"")

 

[Joe4]

Welcome to the Board!

If it always starts with the 4th space, you could use:

=MID(A1,4,LEN(A1))

If you want something a little more dynamic that takes everything after the first blank space, you can use:

=MID(A1,FIND(" ",A1)+1,LEN(A1))

 

[jamesw81]

Thanks everyone. Will give these all ago.