Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
I have addresses which were entered in cells a1, A2, A3 and so On and I need
to convert them to appear in cells a1, b2, b3 I know I have performed this function in the past but I am drawing a blank please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
Control R will the cell immediately to the left into the current cell.
"Rich0072" wrote in message ... I have addresses which were entered in cells a1, A2, A3 and so On and I need to convert them to appear in cells a1, b2, b3 I know I have performed this function in the past but I am drawing a blank please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
Just venturing a guess here (looking at your subject line) that perhaps what
you're after is to re-arrange "grouped" source data in a column to fit into different separate columns Assuming your data is in A1 down, with the addresses in groups of 3 lines each, e.g.: Add1_Line1 Add1_Line2 Add1_Line3 Add2_Line1 Add2_Line2 Add2_Line3 etc Put in B1: =INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1)) Copy B1 across 3 cols to D1, fill down until zeros appear, signalling exhaustion of data extracted from col A If required, freeze the values by selecting cols B to D, then do an "in-place" copy paste special values ok Adapt this part: ROW(A1)*3-3 to suit the number of lines per group .. (adapt also the "copying across" part accordingly) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Rich0072" wrote in message ... I have addresses which were entered in cells a1, A2, A3 and so On and I need to convert them to appear in cells a1, b2, b3 I know I have performed this function in the past but I am drawing a blank please help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2
... The results in cols B to D will appear as:
Add1_Line1 Add1_Line2 Add1_Line3 Add2_Line1 Add2_Line2 Add2_Line3 etc -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
covert Cellular phone dec to hex | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Converting a link to values to multiple cells. | Excel Worksheet Functions | |||
How does excel automatically covert cells when a different number. | Excel Discussion (Misc queries) | |||
How to covert old Lotus 123 files with .123 extension to Excel? | Excel Discussion (Misc queries) |