Y ysahme New Member Sep 4, 2014 #1 Hi good day to all... I have a string of message i want to break... please help me... this is the sample... 1116-10271689 - 623.00 / 1116-1029158 - 89,100.25 / 72185963 - 10,000.00 How can i break invoice and amount.. Thanks for yourr help in advance...
Hi good day to all... I have a string of message i want to break... please help me... this is the sample... 1116-10271689 - 623.00 / 1116-1029158 - 89,100.25 / 72185963 - 10,000.00 How can i break invoice and amount.. Thanks for yourr help in advance...
Hui Excel Ninja Staff member Sep 4, 2014 #2 Ysahme If you have a column of similar strings, I'd suggest using Text to Column You will have to use a multiple pass approach First use the / as a separator Then use a " - " as a separator on the remaining columns
Ysahme If you have a column of similar strings, I'd suggest using Text to Column You will have to use a multiple pass approach First use the / as a separator Then use a " - " as a separator on the remaining columns
Hui Excel Ninja Staff member Sep 4, 2014 #4 Select the Column Then Goto Data, Text to Columns Follow prompts
Y ysahme New Member Sep 4, 2014 #5 Thanks... It work on the others but not all data will get the same figure or amount..
