Why text to columns works

Craig92604

Well-known Member
Joined
Nov 7, 2002
Messages
505
I use vlookup alot. On some occasions the formula does not work. When I highlight the lookup value column and do a text to column then the formula works. Can anyone explain why this works?
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I expect that the lookup value is a number and the lookup range contains text entries that look like numbers. Text to Columns coerces text entries that look like numbers into true numbers.

You can use the ISNUMBER function to test whether a cell contains a number (TRUE) or text (FALSE).
 

Watch MrExcel Video

Forum statistics

Threads
1,118,537
Messages
5,572,782
Members
412,484
Latest member
deezina07
Top