Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
julia
 
Posts: n/a
Default how do I UN-concatenate cells

I have a string of numbers 00633.84010.12740.0000.10101 that I need to break
out into the separate components.
  #2   Report Post  
Dave O
 
Posts: n/a
Default

Is the string of numbers always 5 numbers, a dot, 5 numbers, a dot,
etc? If it's *always* in that format you can use a MID() function. If
the separate components are between dots but irregularly spaced it
becomes trickier.

If it's the easy scenario, and supposing your string is in cell A1, try
=MID(A1,1,5)
=MID(A1,7,5)
=MID(A1,13,5)
etc

  #3   Report Post  
Graham Haughs
 
Posts: n/a
Default

Hi Julia,
If you try Data Text to Columns and follow the options, this
may be what you are after.

Regards
Graham

julia wrote:
I have a string of numbers 00633.84010.12740.0000.10101 that I need to break
out into the separate components.

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
Concatenate cells without specifying/writing cell address individually Hari Excel Discussion (Misc queries) 4 January 3rd 05 06:05 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM


All times are GMT +1. The time now is 06:30 PM.

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

About Us

"It's about Microsoft Excel"