Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and Replace Command Using Wildcard Help | Excel Discussion (Misc queries) | |||
Find Replace Wildcard | New Users to Excel | |||
remove and replace a digit... | New Users to Excel | |||
Wildcard for finding the first numeric digit in a cell? | Excel Worksheet Functions | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) |