Share via

Put Multiple Actions Into One Function

Anonymous
2017-09-04T23:18:02+00:00

Hi All

I am not too sure if this is possible in Excel however what I am trying to do is take a persons first and last name, change the text to have a capital on each word and lower case there after, remove any spaces at the start then remove everything else other than the first name then copy the result so I have the text and not the formula.

I am using the following and it all works fine:

Name in column B

=PROPER(B1) - in column C

=TRIM(C1) - in column D

=LEFT(B4,FIND(" ",B4&" ")-1) - in column E

Then copy colume E into column F using the paste values option

Then delete columns B, C, D and E 

Now I am left with just the first name in column B.

Is there a way to create a function or action or something to run all of these commands in one go to speed this process up?

If so how do I do it?

Many Thanks

mrmbarnes

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2017-09-05T02:44:54+00:00

    No.  You will have to copy it and then paste special as values before deleting column B.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-09-05T00:21:46+00:00

    Hi

    Thanks for that... it works great however it still leaves the formula and not the text... is there a way to add one more option to turn the formula into text because when I delete the name column that is no longer needed it turns into #REF!

    mrmbarnes

    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2017-09-04T23:55:22+00:00

    Hi,

    Try this

    =PROPER(LEFT(TRIM(B4),SEARCH(" ",TRIM(B4))-1))

    0 comments