| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to create a text number from other columns
I have text numbers in columns C, D, E, F and G. Total of 15 digits split
5-2-4-1-3. In column A, I want to create a 15 digit text number that reads those 15 digits from the five columns. How do I do this? -- Sierra Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to create a text number from other columns
In A1 enter:
=C1 & D1 & E1 & G1 and copy down -- Gary''s Student - gsnu200767 "Sierra Mike" wrote: I have text numbers in columns C, D, E, F and G. Total of 15 digits split 5-2-4-1-3. In column A, I want to create a 15 digit text number that reads those 15 digits from the five columns. How do I do this? -- Sierra Mike |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to create a text number from other columns
hi
use concantenators. =C1 & D1 & E1 & F1 & G1 there is also a built in function =CONCANTENATE(C1,D1,E1,F1,G1) either way. the first is less typing. Regards FSt1 "Sierra Mike" wrote: I have text numbers in columns C, D, E, F and G. Total of 15 digits split 5-2-4-1-3. In column A, I want to create a 15 digit text number that reads those 15 digits from the five columns. How do I do this? -- Sierra Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to columns by any number (not $)? | Excel Discussion (Misc queries) | |||
| CAN YOU CREATE COLUMNS INSIDE A TEXT BOX | Excel Discussion (Misc queries) | |||
| Merging text from 3 columns to create a URL | Excel Worksheet Functions | |||
| Can you create form in Excel & text wraps across several columns? | Excel Worksheet Functions | |||
| wrapping text across a number of columns | New Users to Excel | |||
Linear Mode
