Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 05:51 PM
Peo Sjoblom
 
Posts: n/a
Default separate data in a column in excel

If the values are numbers starting in A1

in B1

=INT(A1)

in C1

=(A1-B1)*100

if they are text

=LEFT(A1,FIND(".",A1)-1)

and

=SUBSTITUTE(A1,B1&".","")

Regards,

Peo Sjoblom



"Larry" wrote:

Is there a function to separate values (besides text to columns) in a column
similar to the formula used to combine data. I'd like to separate a column
of decimals, say 14.25, 5.50 and 100.00 into colums containing 14 and 25, 5
and 50, 100 and 00. Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM
Excel should provide an easy way to switch a column into a row, n. samsson Excel Discussion (Misc queries) 2 March 21st 05 04:20 PM
how do i convert a row of data into a column in another excel wor. MrSkoot99 Excel Worksheet Functions 1 March 20th 05 03:55 AM
want to flip data in an excel column so last is first, first is l. kc Excel Discussion (Misc queries) 4 March 17th 05 10:57 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017