Find Value between characters in one cell
Solved/Closed
CyberPath
Posts
3
Registration date
Wednesday May 4, 2011
Status
Member
Last seen
May 5, 2011
-
May 4, 2011 at 07:47 AM
CyberPath Posts 3 Registration date Wednesday May 4, 2011 Status Member Last seen May 5, 2011 - May 5, 2011 at 04:06 AM
CyberPath Posts 3 Registration date Wednesday May 4, 2011 Status Member Last seen May 5, 2011 - May 5, 2011 at 04:06 AM
Related:
- Find Value between characters in one cell
- Characters in dinosaur game - Guide
- Facebook special characters - Guide
- Kt naruto mod apk unlock all characters - Download - Adult games
- Based on the cell values in cells b77 - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
2 responses
Select column A, assuming that is where the data is, then choose the Text to Columns feature. Choose Delimited and choose the | (pipe) as the delimiter.
Unless some of the fields need special treatment regarding the data type, just click on finish.
Unless some of the fields need special treatment regarding the data type, just click on finish.
CyberPath
Posts
3
Registration date
Wednesday May 4, 2011
Status
Member
Last seen
May 5, 2011
May 5, 2011 at 04:06 AM
May 5, 2011 at 04:06 AM
Thanks RayH
That helped me a lot.
That helped me a lot.