Previous Topic Next Topic

Excel pro

Closed
usha - Feb 24, 2010 at 02:12 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 05:16 AM
Hello,

Can any please help me how do slove below pro
i have two values in excel row i need diffrent value in same cell

exp
A-K8257250058
B-H7036100444
C-H6616801345
D-8060026

i need this data convert in to

AB
CD

K8257250058H7036100444
H66168013458060026
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 24, 2010 at 05:16 AM
So you want to change 

          A
A-K8257250058
B-H7036100444
C-H6616801345
D-8060026



To This ? 
           A
AB
CD
-
K8257250058H7036100444
H66168013458060026


Thus
join row 1 and row 2 value together (before -) in row 1
join row 3 and row 4 value together (before -) in row 2
a blank row
join row 1 and row 2 value together (after -) in row 4
join row 3 and row 4 value together (after -) in row 5
?
0