tag:blogger.com,1999:blog-1869924468172210809.post3397168166299475233..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Converting numbers to text - retrospectivelyGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1869924468172210809.post-19786118605272546762014-03-25T17:32:16.999+00:002014-03-25T17:32:16.999+00:00Brian
I would agree wholeheartedly wiith your poi...Brian<br /><br />I would agree wholeheartedly wiith your point about not editing raw data. This was what the client was using it for and I recommended that the spreasdheet should be altered to expect the data in this format rather than change it each time. The times I am talking about are where you have data that was originally entered with no validation or structure and you may be mapping to raw data pulled from a system. This is a quick solution to getting the existing data into the new format (to match the format of the raw data that you are referencing.<br /><br />I like your array formula though. I can see that being handy where I can't guarantee that the two data tables can match going forward.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-19705327352008548762014-03-25T17:14:23.614+00:002014-03-25T17:14:23.614+00:00I have never had to F2 all the way down (wee,wee,w...I have never had to F2 all the way down (wee,wee,wee,....)<br />First I am not sure why you would need to do the conversion for Vlookup.<br />Second you could array enter =VLOOKUP(""&A1,""&E2:F6,2,0) which would convert your search item and lookup table to text without actually changing your data. <br />Third it is not good practice to change raw data in any way. If you do text to columns your destination should not overlap your source.<br />Regards<br />BrianBrianhttps://www.blogger.com/profile/06063334745698094480noreply@blogger.com