Hello Forum Experts,
Is it possible to perform a function in Access 2010 like the "Text to Columns" function in Excel?
I would like to split concatenated text in one column and place into a new column.
Example: 5551111-Blue- Play
I would like to split the "5551111" number and place it in its own cell.
Any suggestions?![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Is it possible to perform a function in Access 2010 like the "Text to Columns" function in Excel?
I would like to split concatenated text in one column and place into a new column.
Example: 5551111-Blue- Play
I would like to split the "5551111" number and place it in its own cell.
Any suggestions?
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)