clock1
asked on
Remove space at beginning of cell in Excel
Have an Excel worksheet that contains 600 rows of data in a single column (Col A).
Each cell in Col A contains text proceeded by a space, example: " Text"
Is there a function or argument that I can use to remove the space from each cell in Col A?
Each cell in Col A contains text proceeded by a space, example: " Text"
Is there a function or argument that I can use to remove the space from each cell in Col A?
try = trim(a1)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
+Trim(A1)