Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge words in diff cols to one
i have a small doubt. If suppose i entered my full name, Joe George Thomas,
in 3 columns and if i want to merge those all three to one single column, and read that as a full name, how can i do that? Thanx n rgds joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge words in diff cols to one
Hi!
Try this: A1 = Joe B1 = George C1 = Thomas =A1&" "&B1&" "&C1 Biff "Joe" wrote in message ... i have a small doubt. If suppose i entered my full name, Joe George Thomas, in 3 columns and if i want to merge those all three to one single column, and read that as a full name, how can i do that? Thanx n rgds joe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge words in diff cols to one
=A1 & " " & B1 & " " & C1 entered in D1
When happy with the results you may want to copy D1 and paste special(in place)valuesokesc You can clear A1, B1 and C1 Gord Dibben MS Excel MVP On Sun, 22 Jan 2006 22:04:02 -0800, Joe wrote: i have a small doubt. If suppose i entered my full name, Joe George Thomas, in 3 columns and if i want to merge those all three to one single column, and read that as a full name, how can i do that? Thanx n rgds joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number to words literal | Excel Worksheet Functions | |||
Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
Serious Mail Merge Problem | Excel Discussion (Misc queries) |