Suggest Autocomplete Script for Excel

Asked By Donna Davis 20 points N/A Posted on - 11/24/2012

The text/numerics in the first three columns of a worksheet determine the text/numerics in the fourth column. Can anyone please suggest the best autocomplete script for excel together with the entire procedure for successfully inserting it?

Thanks.

• Status: Open
• Question Views: 783
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By shwanj whudson 0 points N/A #137216

Suggest Autocomplete Script for Excel

Hello Mr. Donna Davis,

I thing you are asking about the combining of the cell in one String(in one cell)

I have formula u can use that

Formula:

My

Name

is

Donna

Davis

My Name is Donna Davis

=A1&" "&B1&" "&C1&" "&D1&" "&E1

Use this formula

I think this will help you to solve the problem.

Regards,

Shwanj Whudson

About shwanj whudson

Questions
0

Answers
30

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 11/24/2012
• Question Category: MS Excel