Trim / Substitute Question - Removing CERTAIN Spaces from names in a column

[danielrussell2]

First post, hope I'm doing everything correctly...I tried searching this and couldn't find what I needed and I'm in a bit of a hurry, so I hope I explain myself well enough that someone can help quickly.

Ok, so here goes:

I copied and pasted a table of data from a website - columns have a name, a position, and statistics for each person. The names came ranked in a single column like this (without the quotations):
"1. Bob Henry"

I used text to columns to get rid of the "1." for each person, with no issues. But now I am left with " Bob Henry". I need to remove the FIRST space ONLY, leaving "Bob Henry". I've tried several formulas - text to columns with a space delimeter doesn't work, it gives me " Bob" and "Henry" in separate columns. I tried the Trim, Substitute, and Trim/Substitute combined, and it just gives me " BobHenry" with the space still in front of the names. I want to only remove the space before the name, and leave the rest.

Can someone help? I'm so frustrated with this...

 

[JoeMo]

If that's really a space before "Bob", TRIM should remove it. More likely, coming from a website, it's some other character, maybe a nonbreaking space. See here:Removing Blank Characters or Nonbreaking Spaces from text | Dedicated Excel

 

[Noodleski]

If it's only the first character you want to get rid of, try with the right formula:

RIGHT(A2,len(A2)-1).

Then it doesn't matter what character it is.

 

[danielrussell2]

If it's only the first character you want to get rid of, try with the right formula:

RIGHT(A2,len(A2)-1).

Then it doesn't matter what character it is.

Awesome! Worked like a charm!