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
1	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>
</tbody>

Sheet16​

Worksheet Formulas Cell Formula C1 =RIGHT(A1,LEN(A1)-15) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

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)