format text

[pgh2377]

I have several excel cells that have a text string and then a character space after it, so when I do a vlookup it doesn't work. In other words,how do I go from "Chris " to "Chris".

 

[SkipVought]

Hi,

Use the TRIM function in your lookup formula to get rid of the trailing space.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}