I have a long column containing numbers, characters and text. I want to use and equation to extract the numbers to the left of the “ and place that information in the adjoining cell. Examples of cell contents are as follows:
40" 27.6# NEWS
37.5" 40# COATED
21.75" 30# NEWSPRINT
18" 30# NEWS
18" 30# NEWS
21.75" 30# NEWS
21.75" 30# NEWS
Cell content is in column “E”. Want the result to appear in column “F”.
In the first line of the example I need the 40 to appear in column “F”
In the third line of the example I need the 21.75 to appear in column “F”
Please, can anyone provide an equation to accomplish the task?
Last edited by hawk93; 02-01-2012 at 02:48 PM.
For example
=--LEFT(E2,search("""",E2)-1)
in F2 and copy down.
Good luck.
Thank you OEGO! Perfect!
I save my remaining two wishes for the genie of the magic lamp till a later date.
Thank you again,
Hawk93
My pleasure. Please do not forget to mark this question Solved.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks