Sorting bank statement. Remove "CHECKCARD 1229 " from the beginning of description?

[snapajap]

Hi,

So tax time is here again and I have to sort my statement via vendor. Most descriptions begin like this CHECKCARD 0106 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA
I need to sort by vendor name, so it should read like this AMAZON MKTPLACE PMTS AMZN.COM/BILLWA. So I'd like to be able to remove the CHECKCARD 0106 (including the space at the end) and I have a lot of entries.

Thanks for any help!

 

[JoeMo]

If the "CHECKCARD ####... " is consistent across all entries try this:

Excel Workbook
	A	B
1	CHECKCARD 0106 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA	AMAZON MKTPLACE PMTS AMZN.COM/BILLWA
Sheet1

 

[jtakw]

Hi,

If the string Always starts with CHECKCARD #### and a space, this will also work:

Book1
	A	B	C
1	CHECKCARD 0106 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA		AMAZON MKTPLACE PMTS AMZN.COM/BILLWA
Sheet16

Cell Formulas
Range	Formula
C1	=RIGHT(A1,LEN(A1)-15)

 

[JoeMo]

Hi,

If the string Always starts with CHECKCARD #### and a space, this will also work:

	A	B	C
CHECKCARD 0106 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA	AMAZON MKTPLACE PMTS AMZN.COM/BILLWA

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

</tbody>

Sheet16​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C1[/TH]
[TD="align: left"]=RIGHT(A1,LEN(A1)-15)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

For the OPs benefit, I want to point out that the formula in post #2 will work with any number of digits following the first space, not just 4 digits as provided in the OP's example.

 

[jtakw]

Another option, non length dependent from 2nd space back:

Book1
	A	B	C
2	CHECKCARD 0106 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA		AMAZON MKTPLACE PMTS AMZN.COM/BILLWA
3	CHECKCARDs 01206 AMAZON MKTPLACE PMTS AMZN.COM/BILLWA		AMAZON MKTPLACE PMTS AMZN.COM/BILLWA
Sheet16

Cell Formulas
Range	Formula
C2	=MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,255)