danielrussell2
New Member
- Joined
- Mar 17, 2016
- Messages
- 17
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...
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...