Is there a formula that will extract the number and not the letters in a cell?
Example
a1 a2
123 xyz 123
I need a formula in cell a2 that will pull the 123 only from cell a1.
Thanks
Is there a formula that will extract the number and not the letters in a cell?
Example
a1 a2
123 xyz 123
I need a formula in cell a2 that will pull the 123 only from cell a1.
Thanks
Hi Cassi,
If the format is always some amount of numeric digits, followed by a space, and you only want to return the numeric digits, you could use:
=LEFT(A1,FIND(" ",A1)-1)
That works great except there are some instances were cell a1 is only numeric so this formula makes it return a #VALUE!
Is there a way to solve for this problem as well at the same time?
Thanks
Sure, try:
=IF(ISNUMBER(A1),A1,LEFT(A1,FIND(" ",A1)-1)+0)
=left(a1,find(" ",a1&" ")-1)+0
Worked great! Thanks
You're Welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks