"Data Problem-Data show only?"

[keong04]

Hi ! Guys & Ladies !
I have a question to ask ! I have the data (abc 1234) , then i us
"text to colum" to make it no space between charaters & word(abc1234)
The following step is like that :

1. Select the "data" > data > text to column > select fixed width
next > then create a break line to the desired position > next
finished .

2 . then the data (abc 1234) in column a1 will change to (abc) i
column a1 & 1234 will place at column b1 . Then in column c1 ente
formula =(a1&b1) . Then the abc & 1234 will combine to 1 (abc1234) i
column c1 .

Now is the question time ! If I want to copy out the fina
data(abc1234) in column c1 to other sheet or workbook ? How ? i had tr
to copy but i just can copy the formula only ??? why ? Thank you fo
any1 can help ! Thanks a lot

Attachment filename: data.bmp
Download attachment: http://www.excelforum.com/attachment.php?postid=54778

 

[DNF Karran]

You need to copy then select "Paste Special" from the Edit menu. Selec
"Values" from the option box that appears.

Dunca

 

[Gord Dibben]

keong

Macro solution for deleting all spaces in a cell or selection of cells.

Public Sub Strip_WhiteSpace()
Selection.Replace What:=" ", _
Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub

Gord Dibben Excel MVP