[Formulawiz]

I have a pitchers name in a cell called Y. Carmona
I would like to get rid of the period and get in another cell such as
Y Carmona
What is the excel formula

[dirk93]

Data -> Text to columns -> Delimited -> Other (place a period in the box) -> Finish

Let's say that puts "Y" in A1 and "Carmona" in B1

Then in C1 use =A1&B1

If you are just using this for Y. Carmona, this will work (Y. Carmona is in A1): =LEFT(A1,1) & " " & RIGHT(A1,7)

[Peregrine Stoop]

just thought about creating a school to make people Excel formula masters.... valuable skill

One issues with the second way above is that it only works for a pitcher with exactly 7 letters in his last name. Better to use a middle function starting at spot 4 and going on long enough to get any last name.

[Emily_Haines]

=substitute(a1,".","")

[Formulawiz]

=substitute(a1,".","")

Thanks worked fine

[arwar]

i don't know about Excel functionalities themselves and their relative ease of use, but a ton of data manipulation can be done on files (like .csv files) before import to Excel - simply by using the Edit--->Find/Replace functions in Notepad. for example in the other thread he wanted to get rid of the -R and -L on tbe pitchers.