M mr moe Registered User. Local time Today, 10:41 Joined Jul 24, 2003 Messages 332 May 2, 2007 #1 I have a column that consist of sentence, how do i parse the first word only, for example LP200 ag, 500, how do i cut LP200 and replace it in a new column. Thanks.
I have a column that consist of sentence, how do i parse the first word only, for example LP200 ag, 500, how do i cut LP200 and replace it in a new column. Thanks.
W WayneRyan AWF VIP Local time Today, 10:41 Joined Nov 19, 2002 Messages 7,122 May 2, 2007 #2 Mr. Moe, In a query: NewField: Mid(YourField, 1, InStr([YourField], " ") - 1) Wayne
M mr moe Registered User. Local time Today, 10:41 Joined Jul 24, 2003 Messages 332 May 2, 2007 #3 WayneRyan you are the best.
