find & replace - digit wildcard
If I were using Word, I would enter ^#^#^#^#^#^#^#^#^#^#^#^#^#^#^# in the
Find field to find any 15-digit number. Is there an equivalent in Excel? What I'm trying to accomplish is to eliminate the 23 digits of useless information in the description of every checkcard transaction in the spreadsheet of my transaction history that I've downloaded from my bank. TIA! |
find & replace - digit wildcard
Are the 23 digits of useless information always in the same position in the
field? Like always at the end or beginning or is it random? Also, what is in the field? Is it exclusively the 15+23 digits? or is there other information? If the data is stand-alone and always in the same position you can use the LEFT or RIGHT formulas to only pull in what you want. |
find & replace - digit wildcard
ANSWERS BELOW
Are the 23 digits of useless information always in the same position in the field? Like always at the end or beginning or is it random? AT THE END OF THE FIELD, BUT EACH ROW OF THAT COLUMN DOES NOT ALWAYS HAVE THE 23-D Also, what is in the field? Is it exclusively the 15+23 digits? or is there other information? THERE IS OTHER INFORMATION + THE 23-D (the 15-d was just for illustrative purposes) Thanks! |
All times are GMT +1. The time now is 07:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com