squidmark
Board Regular
- Joined
- Aug 1, 2007
- Messages
- 105
Hi all.
I've got a bank statement listing of cleared checks. But two columns of checks with the check number, date and amount all show up in one cell. for example, cell A1 is:
90341* Aug 22 100.00 91512* Aug 06 456.37
I'd like to take 8 columns and have the first column show what is before the first space (the first check# - 90341*, in this case), then the second column show what is between the first and 2nd spaces, etc.
I've got the '90341*' and "Aug 22" seperated into two columns using a =Find("Aug") function and pulling the data a certain number of characters to the left or right of the text place returned by the Find(Aug) function. But I run into problems when the dollar amounts are varying character lengths. So it just dawned on me that the geniuses at this board could probably help me just show what is between the spaces in seperate columns.
thanks.
I've got a bank statement listing of cleared checks. But two columns of checks with the check number, date and amount all show up in one cell. for example, cell A1 is:
90341* Aug 22 100.00 91512* Aug 06 456.37
I'd like to take 8 columns and have the first column show what is before the first space (the first check# - 90341*, in this case), then the second column show what is between the first and 2nd spaces, etc.
I've got the '90341*' and "Aug 22" seperated into two columns using a =Find("Aug") function and pulling the data a certain number of characters to the left or right of the text place returned by the Find(Aug) function. But I run into problems when the dollar amounts are varying character lengths. So it just dawned on me that the geniuses at this board could probably help me just show what is between the spaces in seperate columns.
thanks.