Hello,
I hope someone could point me in the right direction for this data I need to sort. In general it looks like this: All in one column
flight 1.1
flight 1.2 paid $50 owes $100
flight 1.5 paid $80
pass paid $125
ground 1.2 flight .9
checkout flight 1.2 paid $76
I need to extract the numbers with a $ sign into a separate column. to look like this:
light 1.1
flight 1.2 paid $50 owes $100...........50..........100
flight 1.5 paid $80................................80
pass paid $125...................................125
ground 1.2 flight .9
checkout flight 1.2 paid $76...............76
.............. representing separate columns
If anyone knows of an easy way to do this please let me know. I tried the text to columns feature using the $ but it only worked for 1 or 2 of the cells. Since all the data I want is preceded by a $ symbol I hope this can be done.
Thanks again.