Posted: Mon Nov 28, 2011 9:41 pm Post subject: extract part of string
I have a column were each cell has a combination of char and numbers in its string. Each cell has different char and numbers except that they all have a longitude and latitude follow their respective number, and thats what i want to extract to another empty column.
example:
Column A
row 1 1863, charlston, #360 latitude: 53.567964385 longitude: 11.021423488
row 2 1902, kings, #121, 33FG, cornwell 22DR latitude: 52.567964227 longitude: 11.998623411
What i need is the number for latitude extracted to one column and the number for longitude to another column...
Anyone got a statement for that?
Hi,
Try these:
=MID(A1,9+FIND("latitude:",A1),LEN(A1)-FIND("longitude:",A1)-9)
=RIGHT(A1,LEN(A1)-FIND("longitude:",A1)-10)
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
Menu Bar/Data/texttocolumns/delimiter :
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks