longbow2000
Board Regular
- Joined
- May 5, 2004
- Messages
- 59
- Office Version
- 365
- Platform
- Windows
Good Day
How do convert text to columns IF the imported text will be more than 256 columns when the converted?
Or is there another approach to my desired end result, as described below?
All of the imported text is in Cell A1 as a singe row, i.e. (45,23,4,5,…etc). I then convert it via text to columns, then copy / paste special as Transposed text so that all the data is in rows. This works 100% if the text to column data in less than 256.
Thanx in advance
Ivan
How do convert text to columns IF the imported text will be more than 256 columns when the converted?
Or is there another approach to my desired end result, as described below?
All of the imported text is in Cell A1 as a singe row, i.e. (45,23,4,5,…etc). I then convert it via text to columns, then copy / paste special as Transposed text so that all the data is in rows. This works 100% if the text to column data in less than 256.
Thanx in advance
Ivan