I have a large dataset of customer information generated within the same column. I need to separate them into two columns: emails and dates
Currently, the format looks like the following:
emails and dates.JPG
In short, the lengths of the email addresses greatly vary, and the months and dates vary as well (1 or 2 digits).
Thank you all in advance.
if the first cell is in A2
then in b2 put
Formula:
Please Login or Register to view this content.
and C2
Formula:Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks