I have an excel file with records(rows) that contain(have combined) multiple fields(columns) into one cell and am looking to break the data out into their own columns. I know where to split the record by identifying the start and end positions where there are more than one space between each text. For example, this is one record.
<tbody>
</tbody>
This is how it should look:
<tbody>
</tbody>
I would like to break these 4 pieces of text into their own column.
My questions is, Is there a formula to identify the start and end position where there is more than one space. For example
<tbody>
</tbody>
And so on…. Is there a way to do this?
Please let me know if this isn’t clear.
Thanks in Advance!!
Name Address Age Gender |
<tbody>
</tbody>
This is how it should look:
Name | Address | Age | Gender |
<tbody>
</tbody>
I would like to break these 4 pieces of text into their own column.
My questions is, Is there a formula to identify the start and end position where there is more than one space. For example
- Between Name and Address, there are 10 spaces so I would be looking for a start position of 5, and end position of 10. The formula to produce the 5 and 10 could reside in separate cells on the spreadsheet.
- Between Address and Age, there are 7 spaces so I would be looking for a start position of 18, and end position of 25. The formula to produce the 5 and 10 could reside in separate cells on the spreadsheet.
Data | Start of 1st Position w/ more than one space | End of 1st Position w/ more than one space | Start of 2nd Position w/ more than one space | Start of 2nd Position w/ more than one space |
Name Address Age Gender | 5 | 10 | 18 | 25 |
<tbody>
</tbody>
And so on…. Is there a way to do this?
Please let me know if this isn’t clear.
Thanks in Advance!!
Last edited: