Is it possible for Excel to run an equation based on a cell that contains a word and a number. For example:
A1 = $100,000
A2 = Bob 15
A3 = James 8
A4 = Michelle 18
Can excel identify the number and multiply by $100,000??
Is it possible for Excel to run an equation based on a cell that contains a word and a number. For example:
A1 = $100,000
A2 = Bob 15
A3 = James 8
A4 = Michelle 18
Can excel identify the number and multiply by $100,000??
Last edited by NBVC; 02-10-2011 at 08:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks