Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove space at beginning of each name
I recieved a list that has several hundred names that I was going to do a
VLOOKUP on to put in some data from another spreadsheet. The list I received has one space at the beginning of each name so the VLOOKUP won't work. How can I remove this space without going into every single cell and deleting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove space at beginning of each name
Say the names are in A1 thru A1000. In B1 enter:
=TRIM(A1) and copy down You can then copy column B and PasteSpecialValue back onto column A if you like. -- Gary''s Student - gsnu200768 "Supe" wrote: I recieved a list that has several hundred names that I was going to do a VLOOKUP on to put in some data from another spreadsheet. The list I received has one space at the beginning of each name so the VLOOKUP won't work. How can I remove this space without going into every single cell and deleting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove space at beginning of each name
You could use:
Select the column Data|Text to columns Fixed width (but remove any lines that excel guessed) and finish up. But both leading and trailing spaces will be chopped off. Multiple internal spaces won't be changed. =trim() will get rid of leading/trailing and multiple internal spaces. Supe wrote: I recieved a list that has several hundred names that I was going to do a VLOOKUP on to put in some data from another spreadsheet. The list I received has one space at the beginning of each name so the VLOOKUP won't work. How can I remove this space without going into every single cell and deleting? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove space at beginning of each name
how about
for each c in range("a2:a22") c.value=ltrim(c) next c -- Don Guillett Microsoft MVP Excel SalesAid Software "Supe" wrote in message ... I recieved a list that has several hundred names that I was going to do a VLOOKUP on to put in some data from another spreadsheet. The list I received has one space at the beginning of each name so the VLOOKUP won't work. How can I remove this space without going into every single cell and deleting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove blank space? | Charts and Charting in Excel | |||
How to remove a space | Excel Discussion (Misc queries) | |||
eliminate space at beginning of line | Excel Worksheet Functions | |||
Remove Spaces beginning Time entry | Excel Discussion (Misc queries) | |||
How do I remove a blanck space from the beginning of a formula? | Excel Worksheet Functions |