Removing spaces from text or numbers in cells
in Microsoft Excel
To play this video you must have installed the free
Adobe
Flash Player, please click the link to install it if the video
below doesn't run.
Formula used in demonstration
|
-
=VLOOKUP(A2,patient!A:N,4,FALSE)
-
Use Replace from the Edit menu
-
Enter a space in the "Find what" text box
-
Enter nothing in the "Replace with" text box
|
|
