By Kailas Bairagi on Thursday, 13 February 2020
Posted in Excel
Replies 3
Likes 0
Views 5.6K
Votes 0
Hi, i have below information in one cell:- Information,09 February 2020 04:40:59,Surface: P1,KOS,Point 7323.907000, 5342.948500, 16.399000 ignored - duplicate.
I want to use 7323.907000, 5342.948500, 16.399000 only. & i want 7323.907000 in one separate cell, 5342.948500 in separate cell, 16.399000 in separate cell.
& like this i have thousands of coordinates want to make small formula to generate direct output file please help me out with this.
want to use specific information in 3 different cells. Thanks.!!!!!!
This in one cel?

Information,09 February 2020 04:40:59,Surface: P1,KOS,Point 7323.907000, 5342.948500, 16.399000 ignored - duplicate.
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
see attachment for the macro
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you so much @japiejoo its really helpfull.
·
4 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post