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


in C1


if they are text





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.

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 10:50 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