Forum home » Delegate support and help forum » Microsoft Excel Training and help » Text to columns

Text to columns

ResolvedVersion 2003

Mon 17 Aug 2009, 16:56 Delegate Carolyn said...

Carolyn has attended:
Excel Intermediate course

Text to columns

if I have 2 cells, one with first name and one with surname, how do I merge the two columns together?

Tue 18 Aug 2009, 11:41 Trainer Amanda said...

RE: text to columns

Hello Carolyn

Thank you for your question and welcome to the forum.

I think that this could be achieved using the Concatenate function.

Please see the attached notes - I hope this helps.

Kind regards
Amanda

Attached files...

Concatenate.doc

Tue 25 Aug 2009: Automatically marked as resolved.

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Text to columns

Text to columns

RE: text to columns

Attached files...

Excel articles

Excel tip:

Hiding and unhiding rows using the keyboard