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
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Special characters facebook - Guide
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.