help extracting info from a cell after a "."

[joeloveszoe]

hi
i have a spreadsheet, all info in a row starts with a compatible with and a part number or two. how do i separate out all of the info AFTER the "." int a new cell

thank so much!!

Compatible with CB390A, 825A. Fits Models: Color LaserJet CP6015, CP6015N, CP6015DN, CP6015DE, CP6015X, CP6015XH, CM6030, CM6040 MFP
Compatible with C8553A, 822A. Fits Models: Color LaserJet 9500, 9500GP, 9500HDN, 9500MFP, 9500N
Compatible with CE740A. Fits Models: Color LaserJet Professional CP5220, CP5225, CP5225DN, CP5225N
Compatible with CF383A. Fits Models: Color LaserJet Pro MFP M476, M476DN, M476NW, M476DW

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	Compatible with CB390A, 825A. Fits Models: Color LaserJet CP6015, CP6015N, CP6015DN, CP6015DE, CP6015X, CP6015XH, CM6030, CM6040 MFP	Fits Models: Color LaserJet CP6015, CP6015N, CP6015DN, CP6015DE, CP6015X, CP6015XH, CM6030, CM6040 MFP
3	Compatible with C8553A, 822A. Fits Models: Color LaserJet 9500, 9500GP, 9500HDN, 9500MFP, 9500N	Fits Models: Color LaserJet 9500, 9500GP, 9500HDN, 9500MFP, 9500N
4	Compatible with CE740A. Fits Models: Color LaserJet Professional CP5220, CP5225, CP5225DN, CP5225N	Fits Models: Color LaserJet Professional CP5220, CP5225, CP5225DN, CP5225N
5	Compatible with CF383A. Fits Models: Color LaserJet Pro MFP M476, M476DN, M476NW, M476DW	Fits Models: Color LaserJet Pro MFP M476, M476DN, M476NW, M476DW
Main

Cell Formulas
Range	Formula
B2:B5	B2	=TRIM(REPLACE(A2,1,FIND(".",A2),""))

 

[joeloveszoe]

How about

Fluff.xlsm
	A	B
1
2	Compatible with CB390A, 825A. Fits Models: Color LaserJet CP6015, CP6015N, CP6015DN, CP6015DE, CP6015X, CP6015XH, CM6030, CM6040 MFP	Fits Models: Color LaserJet CP6015, CP6015N, CP6015DN, CP6015DE, CP6015X, CP6015XH, CM6030, CM6040 MFP
3	Compatible with C8553A, 822A. Fits Models: Color LaserJet 9500, 9500GP, 9500HDN, 9500MFP, 9500N	Fits Models: Color LaserJet 9500, 9500GP, 9500HDN, 9500MFP, 9500N
4	Compatible with CE740A. Fits Models: Color LaserJet Professional CP5220, CP5225, CP5225DN, CP5225N	Fits Models: Color LaserJet Professional CP5220, CP5225, CP5225DN, CP5225N
5	Compatible with CF383A. Fits Models: Color LaserJet Pro MFP M476, M476DN, M476NW, M476DW	Fits Models: Color LaserJet Pro MFP M476, M476DN, M476NW, M476DW
Main

Cell Formulas
Range	Formula
B2:B5	B2	=TRIM(REPLACE(A2,1,FIND(".",A2),""))

excellent - thanks soooo much!!!!!

 

[Tom.Jones]

In B1

=MID(A1,FIND(". ",A1)+2,500)

 

[Fluff]

Glad to help & thanks for the feedback.