Text and data separated by a colon

[burnsnd85]

I need to copy one column of info with text and data separated by a colon (customer one:12345) and only paste the data (12345) into the second column. Simpler solution preferred. Any suggestions?

 

[njimack]

=right(a1,len(a1)-find(":",a1))

Or use Text to Columns, with ":" as your delimiter

 

[MrKowz]

Try using Text-To-Columns, using ":" as the delimiter. It will put "Customer One" in the first column, and the ID number in the second column.

 

[T. Valko]

I need to copy one column of info with text and data separated by a colon (customer one:12345) and only paste the data (12345) into the second column. Simpler solution preferred. Any suggestions?

Paste the data then do a Text to Columns operation.

• Delimited>Other>enter a colon
• Next
• Do not import
• Finish

 

[burnsnd85]

Beerholder: I'm trying but not having any success. Should I use your formula with 'Find and Replace'?

 

[burnsnd85]

That was easy. Thanks.

 

[njimack]

Beerholder: I'm trying but not having any success. Should I use your formula with 'Find and Replace'?

Huh? Just enter it into a cell, assuming your text is in A1