I want to create a chart with data generated from another program. My problem is that Excel won't recognize the data as numbers because the unit is appended to each value (ex: 50km, 5s, etc.). Is there a way to tell excel to just use the numeric values and ignore the letters?
one way is to strip the text via formula. Assumes a number/text value in B2
this is an array formula so comit with CTRL+SHIFT+ENTER
=LEFT(B2,MIN(IF(ISERROR(FIND(CHAR(ROW(65:90)),UPPER(B2))),LEN(B2)+1,FIND(CHAR(ROW(65:90)),UPPER(B2))-1)))*1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks