kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 270
When I pasted the two columns x 60 rows, Excel put everything into A1.
So it appears as 16055spacespaceText Textspacespace8956spacespaceTextText and so on.
I thought I could do a find and replace. I wanted Excel to find spacespace and replace it with ,spacespace. That would give me a comma delimited file and I could flow it in as two columns one numeric in A1 and Text in B1.
I am using Excel 2000 with W2K. Excel 2000 does not recognize spaces as a character so the find and replace thing does not work. Is there a work around?
Oh, yes, spacespace is my way of showing you all that there are two space characters between the numbers and the text.
k
So it appears as 16055spacespaceText Textspacespace8956spacespaceTextText and so on.
I thought I could do a find and replace. I wanted Excel to find spacespace and replace it with ,spacespace. That would give me a comma delimited file and I could flow it in as two columns one numeric in A1 and Text in B1.
I am using Excel 2000 with W2K. Excel 2000 does not recognize spaces as a character so the find and replace thing does not work. Is there a work around?
Oh, yes, spacespace is my way of showing you all that there are two space characters between the numbers and the text.
k